1
vote
0answers
25 views

Should SQL Server backups be scheduled in SQL Server Agent or as a Scheduled Task?

I have inherited a system where a system where our database is backed up by identical scripts, one set up in SQL Server Agent and one set up as a Scheduled Task. Both are running at the same time, so ...
0
votes
2answers
123 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
0
votes
2answers
107 views

Backup for SQL & Server 2008 R2?

What's the best/easiest backup solution for my use case? Windows Server 2008 R2 Has a finance program called The Financial Edge (Blackbaud) that uses SQL Server 2008 R2 to keep its database Stores ...
0
votes
0answers
82 views

MSSQL 2008 R2 Restore VSS

We have a Windows 2008 R2 server which has 2 disks of which one is used as a backup disk for Windows Backup with VSS enabled. We also have MSSQL 2008 R2 running on this server. If I want to restore a ...