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********@yahoo.com> napisa³ w wiadomo¶ci
news:je****************@nwrdny03.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********@yahoo.com> wrote in message
news:je****************@nwrdny03.gnilink.net...

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

Thank you

[n0t999]

"mike" <mi********@yahoo.com> wrote in message news:<je****************@nwrdny03.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