I am a rookie and need help in backing up data

  • Thread starter Thread starter hkjamjam
  • Start date Start date
H

hkjamjam

I am using SQL Server 2000 Enterprise Version on W2k, with a IBM LTO tape
drive,
I got a question about backup the database, I schedule the task in window to
backup at mid night and it runs, but it doesn't backup the database, is it
becuase the SQL Is In Use? I can backup folders file by this method, So what
should I do?
I am using W2K internal Backup application.

Extra question: I have a production server which is in another domain, can I
backup it too??I cann get connect to the server to back up it.
 
I am using SQL Server 2000 Enterprise Version on W2k, with a IBM LTO tape
drive,
I got a question about backup the database, I schedule the task in window to
backup at mid night and it runs, but it doesn't backup the database, is it
becuase the SQL Is In Use? I can backup folders file by this method, So what
should I do?
I am using W2K internal Backup application.
Click to expand...

Use the SQL Backup, bets accessed through the maintenance wizard. You
can back to tape, or to a backup folder that you back up to tape in
the normal fashion. Pay attention to transaction logs as well, SQL
backups are an art to themselves.

Jeff
 
Back
Top