Groups | Blog | Home
all groups > sql server (alternate) > july 2003 >

sql server (alternate) : Can I Backup A Database On CD?


mike
7/7/2003 11:57:03 AM
If I copy a Database backup to a CD; can I resotre to a different server?

Thank you

John Bell
7/7/2003 1:23:32 PM
Hi

You may have problems in that if you copy files from a CD they will have the
read only attributes set.

The other problems that you may encounter are covered in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546


John

[quoted text, click to view]

clockworkoi
7/7/2003 1:59:38 PM

U¿ytkownik "mike" <mike2002am@yahoo.com> napisa³ w wiadomo¶ci
news:jedOa.5800$19.1431@nwrdny03.gnilink.net...
[quoted text, click to view]
Why not?
/p

n0t999 NO[at]SPAM netscape.net
7/22/2003 4:43:15 AM
[quoted text, click to view]

Yep, but as someone mentioned earlier the 'read only' attribute will
be set on the files - this will make the database show up on SQL
Server as 'Read Only' and when you try to access it, it will come up
with an error. So, once copied onto the destination server's HDD,
remember to reset the file attribute property.

HTH

AddThis Social Bookmark Button