Can I Backup A Database On CD?

[mike]

If I copy a Database backup to a CD; can I resotre to a different server?

Thank you

[clockworkoi]

U¿ytkownik "mike" <mi********@yah oo.com> napisa³ w wiadomo¶ci
news:je******** ********@nwrdny 03.gnilink.net. ..

If I copy a Database backup to a CD; can I resotre to a different server?

Why not?
/p

[John Bell]

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...;en-us;Q314546
John

"mike" <mi********@yah oo.com> wrote in message
news:je******** ********@nwrdny 03.gnilink.net. ..

If I copy a Database backup to a CD; can I resotre to a different server?

Thank you

[n0t999]

"mike" <mi********@yah oo.com> wrote in message news:<je******* *********@nwrdn y03.gnilink.net >...

If I copy a Database backup to a CD; can I resotre to a different server?

Thank you

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

iwg