Copying database between servers

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Copying database between servers

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2006-06-06 : 11:07:50

Hi gurus

I hava a database in server A
i want to copy this database to server B

Pls,Explain me in Steps, since i have tried it many times with out success

Thanks in advance.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-06-06 : 12:20:44

Backup database on server A
copy backup file to server B
restore daatbase on derver B (use move option if paths have changed).

If you have users then you may have to add the logins or match them with the users in the database.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

venkath
Posting Yak Master

202 Posts

Posted - 2006-06-07 : 03:23:30

Thank u very much..
I restored the database using T-SQL

Could u tell me in detail the steps in Enterprise manager..

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2006-06-07 : 04:10:05

Right click on database - all tasks, backup database
add - choose a file name.
ok
That will backup the database to the specified file name.
Then copy the file to the destination server.
On that server
Right click on databases - all tasks, restore database
in restore as database type in the database name
select "from device"
select device - choose the backup file you copied. ok back to the restore frame
click on options tab
There you will see the file names - overtype the physical file name with the path and files where you want it to create the database files.
click ok.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Kristen
Test

22859 Posts

Posted - 2006-06-07 : 04:19:40

Might also need to tick the "Force" checkbox (can't remember when that is needed - to overwrite a pre-existing database maybe, or maybe just if the target MDF exists, I can't remember!)

Kristen

venkath
Posting Yak Master

202 Posts

Posted - 2006-06-07 : 04:56:59

Thanks a lot Nigel
I did it..

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-06-08 : 06:24:30

Backup database on server A
restore backup file to server B

Thanks
KK

Kristen
Test

22859 Posts

Posted - 2006-06-08 : 07:11:13

Which question are you answering CSK?