1
vote
1answer
46 views

SQL Server database backups storage

This is rather basic question. We do backups of all the databases on the server and size around 20GB every week. All that is scheduled (shrinking,Backing up) We store them on Network drive. Now ...
1
vote
2answers
262 views

Transaction log: Truncate vs. backup

I have a SAP ECC instance which runs on SQL Server 2000. The database is set up with the Full recovery model, but a transaction log backup is never done (not my choice). Instead, a full backup is ...
0
votes
2answers
139 views

Should we backup SQL 2000 with ArcServe SQL agent or backup to file and then backup the file?

We have SQL Server 2000 running on Windows Server 2003. We've recently moved to new hardware. We use ArcServe / Brightstor for backups. On the old server we used the SQL agent. We also have agents for ...
0
votes
1answer
80 views

SQL Server 2000 Backups Not Writing to Local Disk

I have several databases on a server. This is the only database backup that fails. It fails from maintenance plans (full backup and transaction log backups) It fails from T-SQL BACKUP commands. ...
2
votes
1answer
81 views

What causes inconsistent SQL 2K backups?

I take weekly full backups of a SQL 2000 database via vanilla Enterprise Manager. The problem happened when I tried to restore the database. I learn that it was not up-to-date as it was pointing ...
3
votes
2answers
1k views

Skip log backup if full backup is running

On some of my SQL2000 servers, I have occasional blocking and weird conflicts between our full backup and log backup jobs. Based on The answers to this SF question, I need to figure out how to prevent ...