backups

  • Thread starter Thread starter Greg Brewer
  • Start date Start date
G

Greg Brewer

I'm having some trouble with backups. My scheduled differential backups of
my sql server database and my server drives are not happening. The only
error message I'm getting is that it failed to start.

Any ideas? Are other people using other software for backups?

If this is not the correct newsgroup, please direct me where I need to be.

Greg
 
Is your SQL Server running during the backup? NT Backup cannot backup open files, so a SQL server would have to be shut down.
If you need to back up your SQL server while it is live you should look at a 3rd party backup software package such as Veritas Backup Exec or CA's Brightstor ARCServe Backup. Each have available Agents which are able to take care of backing up your live database.

If your database is shutdown there are several things that could cause a scheduled task not to start;

Are the credentials of the account under which the task is running correct?
Does the account have the required access?
Are you able to configure the backup and 'Run it Now'?

Hope this helps.

Ian Bagnald
MCSE:Security Windows 2000
MCSA:Security Windows 2000
COMPTIA A+
 
I actually have 2 backup scheduled. One OS and one SQL server. SQL server
has a backup task that can be scheduled. The catch is that I can't find any
indications that the sql backup is actually doing anything. But then I'm
backing up to tape. My plan is to back up to a file then backup the drive.
But for the present, the backup is failing and I can't figure out why from
those highly informative error messages.

Greg

InBan said:
Is your SQL Server running during the backup? NT Backup cannot backup open
Click to expand...
files, so a SQL server would have to be shut down.
If you need to back up your SQL server while it is live you should look at
Click to expand...
a 3rd party backup software package such as Veritas Backup Exec or CA's
Brightstor ARCServe Backup. Each have available Agents which are able to
take care of backing up your live database.
 
That should work, to perform a SQL backup and then a backup of the file, is the file you are backing up to being modified? Honestly I don't work with MSSQL much these days, company I work for is using Oracle, sorry I don't think I can be of much help.

Good luck

Ian Bagnald
MCSE:Security Windows 2000
MCSA:Security Windows 2000
COMPTIA A+
 
I had that trouble with "unprepared" media. Try doing a manual backup
yourself. Just pick one small file and back it up to the tapes you are
wanting to use. Once a good backup has been done once it will overwrite the
tape next time around and do the backup without complaining. Out of a box of
10 tapes I had 7 that worked fine right off without touching them, but 3
from the box needed to be "prepared".

Once you've done it manually, then set a test schedule for 10 minutes in the
future with a few files and see if it runs while your watching it.
 
Ok, I'll try that.

I'm also looking at mirroring. I'm not so much interested in mirroring a
drive to a second drive on the same computer but to a second computer or
even third computer. Something so that if one computer fails then the
second takes over. As for a third computer, I'm thinking a mirror to an
offsite computer. Something so that if something like the power fails for
an extended period, the offsite computer can be kicked into service.

Greg Brewer

Phillip Windell said:
I had that trouble with "unprepared" media. Try doing a manual backup
yourself. Just pick one small file and back it up to the tapes you are
wanting to use. Once a good backup has been done once it will overwrite the
tape next time around and do the backup without complaining. Out of a box of
10 tapes I had 7 that worked fine right off without touching them, but 3
from the box needed to be "prepared".

Once you've done it manually, then set a test schedule for 10 minutes in the
future with a few files and see if it runs while your watching it.

--

Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com



Greg Brewer said:
I actually have 2 backup scheduled. One OS and one SQL server. SQL server
has a backup task that can be scheduled. The catch is that I can't find any
indications that the sql backup is actually doing anything. But then I'm
backing up to tape. My plan is to back up to a file then backup the drive.
But for the present, the backup is failing and I can't figure out why from
those highly informative error messages.

Greg

open
files, so a SQL server would have to be shut down.
Click to expand...
look
at
a 3rd party backup software package such as Veritas Backup Exec or CA's
Brightstor ARCServe Backup. Each have available Agents which are able to
take care of backing up your live database. a
scheduled task not to start; backups to
be.
Click to expand...
Click to expand...
 
Thanks, that should help a lot with my research. I've been looking at dfs
and replicas. I'm not sure if that will do what I want or not; I'm a bit
confused.

Greg

Phillip Windell said:
That would be "Server Clustering".

--

Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com


Greg Brewer said:
I'm also looking at mirroring. I'm not so much interested in mirroring a
drive to a second drive on the same computer but to a second computer
Click to expand...
Click to expand...
 
Back
Top