MDF and LDF file copy while in Read-Only mode? 2

[Ovatvvon]

Hi all,

Just a quick question.

If a database is set to Read-Only, would there be any negative impacts on a database if I copied the MDF & LDF files over to another server to be restored while it continues to run and/or be available? Or is this only something I would need to avoid if writes were occuring to the database?


-Ovatvvon :-Q

 

[mrdenny]

You can not copy the mdf and ldf files if the database is still attached to the SQL Server.

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

 

[SQLBill]

To add to MrDenny's comment:

Well you CAN copy them....they just won't be usable. You will end up with a copy of both files, but they will be considered corrupt by SQL Server when you try to attach them.

-SQLBill

Posting advice: FAQ481-4875

 

[Ovatvvon]

Very interesting. Glad I didn't bother trying to copy them. Together, they are over 50 GB...would've been a waste of several hours of time!

Thank you both!


-Ovatvvon :-Q