dB Copy

[FALCONSEYE]

What is the most efficient way of copying bunch of databases from one server to another? Also, are there any links you can provide for me take a look at?
thanks in advance

http://www.jetansolutions.com

 

[mrdenny]

Backup the databases from the source database and restore them on the destination database.

The other option would be to stop SQL or detach the databases, copy the files then attach them to both servers.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[JackVam]

Depending on the amout of dbs,There is also a Copy database wizard in sql 2005 , but I have found it to be tempremental

All the IT jobs in one place -

http://www.ITjobfeed.com

 

[philhege]

The Copy Database Wizard doesn't play well with relationships. At all. You're better off with backup/restore, or detach/copy/attach if the business can handle the downtime.

 

[SQLSister]

I'm also in the backup restore camp. I have found the wizards in this area to be problematic and not so easy to make sure primary keys and contraints, etc actually get copied as well.

Detach copy and reattach is faster usually than restoring, but normally it is not possible to take the database completely down for that amount of time. A detached database is not accessible by anyone.

"NOTHING is more important in a database than integrity." ESquared

 

[FALCONSEYE]

Hi everybody, I ended up doing a back up / restore. It worked like a charm.

http://www.jetansolutions.com

 

[SQLSister]

plus it gives you practice in case you ever need to do it to actually restore a production db.

"NOTHING is more important in a database than integrity." ESquared

 

[philhege]

Yeah, SQLSister, the constraints are the wizard-killer. We have this crazy-mad customer profile schema that looks almost like the SQL2K5 System Views poster. No way would that go through the Wizard without serious tweaking.

Backup/Restore FTW.