Saturday, February 25, 2012

restore microsoft SQL express 2005 database to another host.

Hi,
Very new to microsoft SQL server 2005 express, so please forgive a
simple question.
I am trying to restore a backup taken on one machine to another. I have
installed 2005 express on both machines along with Microsfot server
management Studio Express.
Step and failures recieved.
1. backed up database bugnet with SQL Server management / database /
tasks / backup.
2. Copied backup to another machine.
3. Created database bugnet ( created same schema as original ).
4. Tried SQL server managment restore and received the following:
system.data.SqlClient.SqlError: the backup set holds a backup from
a database other than the existing 'bugnet'database.
Is there an easy way to restore a 2005 express database to another
machine
Any help is this bread 'n' butter task would be so welcome.
Thanks.Hi,
The best way:
1. You delete the database created by you.
2. Right Click the databases on the server where you want to restore the
database.
3. Click the restore database.
4.Then one screen will come with the name as Restore database
a) In General>> "To database" you write the name of the database.
b) Select from device option, then select the backup file from where you
want to restore the database
c) Select the Backup sets to restore.
5. Then go to the "option" option in left hand side pannel of Restore
Database Screen
a) Here you have to specify the actual path of the MDF and LDF file,
because it will show you the path as per the server from where you took the
backup.
If the file structure is same for both the sql server you can click OK to
restore the database.
Note: If created the database, without delete database step you can carry on
with all other steps with in "option", you have to choose overwrite the
existing database.
Regards
Swaprakash
"lotstolearn" wrote:

> Hi,
> Very new to microsoft SQL server 2005 express, so please forgive a
> simple question.
> I am trying to restore a backup taken on one machine to another. I have
> installed 2005 express on both machines along with Microsfot server
> management Studio Express.
> Step and failures recieved.
> 1. backed up database bugnet with SQL Server management / database /
> tasks / backup.
> 2. Copied backup to another machine.
> 3. Created database bugnet ( created same schema as original ).
> 4. Tried SQL server managment restore and received the following:
> system.data.SqlClient.SqlError: the backup set holds a backup from
> a database other than the existing 'bugnet'database.
> Is there an easy way to restore a 2005 express database to another
> machine
> Any help is this bread 'n' butter task would be so welcome.
> Thanks.
>

No comments:

Post a Comment