I am trying to figure out how to backup sql server.
My company has been backing their database up to tape,
but I found out that it actually hasn't been gettin
backed up to the tape becuase the services for SQL Server
had still been running and hence didn't get backed up
becuase they are in use.

How do I go about (besides turning of the services and
backing up to tape.) backing up all of this data from
enterprise manager so that I could restore this on any
sql server install? Can I just copy the \data folder and
zip it up? Is there a smarter or easier way?

Thanks,

Use the built-in BACKUP and RESTORE commands to backup and restore the
databases. See SQL Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


"cj" <carlwjenkins (AT) hotmail (DOT) com> wrote

I am trying to figure out how to backup sql server.
My company has been backing their database up to tape,
but I found out that it actually hasn't been gettin
backed up to the tape becuase the services for SQL Server
had still been running and hence didn't get backed up
becuase they are in use.

How do I go about (besides turning of the services and
backing up to tape.) backing up all of this data from
enterprise manager so that I could restore this on any
sql server install? Can I just copy the \data folder and
zip it up? Is there a smarter or easier way?

Thanks,