Feeds:
Posts
Comments

Posts Tagged ‘verify sql server backup file is valid’

Quick one today:

In production environments, its a common practice to perform full VERIFICATION of backup files, as part of backup it self. Following script shows verification of backup file:

--
-- Verify backup file
--
RESTORE VERIFYONLY
FROM       DISK = N'H:\MSSQL\Backup\DummyDB_01.BAK'
	,  DISK = N'H:\MSSQL\Backup\DummyDB_02.BAK'
	,  DISK = N'H:\MSSQL\Backup\DummyDB_03.BAK'
	,  DISK = N'H:\MSSQL\Backup\DummyDB_04.BAK'
	,  DISK = N'H:\MSSQL\Backup\DummyDB_05.BAK'
WITH STATS = 1
GO

RestoreVerify

 

Hope this helps,
_Sqltimes

 

Advertisements

Read Full Post »