SQL Server Performance Forum – Threads Archive

copying database

currently i am involved in the process of moving/copying an database about 100 gb to another server , the objects , triggers, stored proc , views everything are dependent on one another.since i am new to this project i could not able to find out, since so many thnigs. other people are also not clear about what’s going on the present server.
in this case what is the best way to copy database to a new server.what are the steps i need to follw to have the copying successfull. thanks in advance

Backup/restore will be best option.
When you use BACKUP/RESTORE it copies everything including data…
Check BOL for BACKUP/RESTORE commands…
MohammedU.
Moderator
SQL-Server-Performance.com

True. After restore in new server don’t forget to fiull update statistics.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You need to sync the users too… I think there is no harm running update statistics after restore but if we are restoring from 2005 to 2005, it is not compulsory… MohammedU.
Moderator
SQL-Server-Performance.com

In my oppinion from 2000 to 2000 or 2000 to 2005 is neccesary.
But from 2005 to 2005 I don’t now.
Could you help me with some information (link) MohammedU.
Thanks, Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>