Question on 'moving' DB

[smathaiv]

Hello,
I have a rather large DB that needs to be moved to another server. I performed a full DB backup; backup file is 29GB.
My plan is to copy *.mdf and *.ldf files to the other server and then attach it to the new DB, but I can't copy the files without taking the DB down.

so the questions are:
1. Is there any way to copy *.mdf and *.ldf files without shutting the DB down?
2. If not, what is the best way to do this?

Any help on this is greatly appreciated.

Thank you.

 

[onpnt]

Backup the database. Move the .BAK (or whatever ext you give it) and Restore it to the new instance

As long as you have a full backup in full recovery mode there is no reason to move the transaction log file either. It will create a new one. The backup you take prior to the move will be your restore point if problems occur

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[ptheriault]

Don't forget to move your logins. Here is an FAQ on how to do that.

faq962-6608

- Paul

- If at first you don't succeed, find out if the loser gets anything.