SQL 2005 Backup Database using T-SQL ServerObjects-->Backup Devices
Posted on 2007-08-08
In SQL 2005 I created a Backup Device that points to the backup location
I this scripted the following:
BACKUP DATABASE Database
TO DISK = N'BackupDeviceName\TrackIT.bak'
WITH Description =N'Full Database Backup'
, NAME = N'DatabaseFullBackup'
It doesn't look for the backup in the device. It is looking for the file in C Drive. Will I actually have to specify the drive D:\backups or can I use the backup device that I created that is already pointing to the drive? Since the Maintnance Jobs are not available in SQL 2005, I planned on running the statement in a scheduled job, is this the best way to do this or is there another way in SQL 2005?