November 7, 2003 at 3:49 am
Hi,
Currently we use Veritas Backup Exec to backup our SQL databases except we do not have the SQL agent for our particular version! So each evening we have to stop the SQL services in order to allow the backup to work.
Is it possible to use for example the DTS to perform a scheduled scripted backup of the database to another network drive whilst the SQL services are still running ? That way our DAT backup should work!
Cheers
Mike
November 7, 2003 at 10:28 am
You should be able to just use the BACKUP DATABASE and BACKUP LOG commands. Use the to disk option and tell it where you want to save the files to. BUT remember, the SQL Server Agent login must have access to that location.
-SQLBill
November 7, 2003 at 10:39 am
Thanks for that, in reading up on the command structures, it appears to create .dat files rather than the actual .mdf and .ldf files. Is this correct ?
I presume if this is the case then the RESTORE command will parse the .dat files back into the .mdf files !
Cheers
Mike
November 10, 2003 at 11:57 am
Yes. The database files themselves are .mdf and .ldf files. Any backups will have different extensions since they aren't 'database files' they are backups of the database files. The RESTORE will return them as .mdf and .ldf files.
-SQLBill
November 10, 2003 at 5:12 pm
Not sure if your saying that you MUST use Netbackup? If you don't need to use Netbackup then why not use the already available SQL Server Maintenance plans. This will allow you to backup any number of databases to a any specified destination and also allows the backups to be scheduled automatically via the SQL Agent job system. No need to stop anything and all scheduled, logged with job success or failure emails sent to wherever you want.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply