Backup & CheckDB Urgent Help
I need some help I have created this scripts to do my backups but I want the backup files to be deleted after the backup has been copied to tape can anyone help?
Backup Database [SPArchive] To
DISK = N'\\.....\e$\Backup\SPArchiveDB.BAK'
WITH INIT, NOUNLOAD, NAME = N'SPArchiveDB Backup',
NOSKIP, STATS = 10, NOFORMAT
Second point I have been running this script on a very small DB and it has been running for the past 3 hours I have no idea what is going on. Early on I did (Backup log SPArchive with no_log). Can anyone help as well?
sp_MSForeachdb @command1 = "print '?'",
@command2= "DBCC CHECKDB (?)"
I look forward to hearing from you.