By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

How to backup up Win2K and SQL server

P: n/a
Tam

Hi,
I am new to Win2k and SQL server and need to back up everything each night.
I used the supplied NT backup utility to schedule a backup but this missed
some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether it
was in use or not.

How or what would you recommend I use to do my backups?
Thanks.
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Tam" <ta**@scotlegal.com> wrote in message
news:IJ********************@wards.force9.net...

Hi,
I am new to Win2k and SQL server and need to back up everything each night. I used the supplied NT backup utility to schedule a backup but this missed
some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether it
was in use or not.

How or what would you recommend I use to do my backups?
Thanks.


Tam,

I use Backup Exec 9.0 with the SQL Agent (which is an extra cost option)
very successfully. It allows the option of restoring individual tables which
is useful and quicker if you have large databases but only need to restore a
few damaged / corrupt tables.

The other option is to create a maintenance plan to backup your databases
before you run NT Backup. The backups can then be backed up to tape because
they will not be open files.

Regards, Stephen.
Jul 20 '05 #2

P: n/a
Tam
Stephen wrote:
"Tam" <ta**@scotlegal.com> wrote in message
news:IJ********************@wards.force9.net...

Hi,
I am new to Win2k and SQL server and need to back up everything each

night.
I used the supplied NT backup utility to schedule a backup but this
missed some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether
it was in use or not.

How or what would you recommend I use to do my backups?
Thanks.


Tam,

I use Backup Exec 9.0 with the SQL Agent (which is an extra cost option)
very successfully. It allows the option of restoring individual tables
which is useful and quicker if you have large databases but only need to
restore a few damaged / corrupt tables.

The other option is to create a maintenance plan to backup your databases
before you run NT Backup. The backups can then be backed up to tape
because they will not be open files.

Regards, Stephen.


Thanks.
Backup Exec was previously on the server before being rebuilt but was not
integrated properly so was taken off.
I will look into this before installing so that we get it right.
--
kno
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.