VALID THE BACKUP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

VALID THE BACKUP

Author

Topic

antony_dba
Starting Member

26 Posts

Posted - 2010-11-29 : 02:27:13

how to check whether backup taken is valid.
To check the validity it has any query..
please suggest

kris

Kristen
Test

22859 Posts

Posted - 2010-11-29 : 02:28:16

Restore it to a different machine and use DBCC CHECKDB (on the restored database on the second machine)

Do this frequently on recent backups to be sure that the backups you are making on Primary Machine are valid

antony_dba
Starting Member

26 Posts

Posted - 2010-11-29 : 02:33:08

how to compress the backup data either(full) or (differential)

kris

antony_dba
Starting Member

26 Posts

Posted - 2010-11-29 : 02:34:28

how to execute the query DBCC CHECKDB whether we have to specify any database name

Thanks for reply
'KRISTEN'

kris

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-29 : 03:44:12

quote:
Originally posted by antony_dba

how to execute the query DBCC CHECKDB whether we have to specify any database name

Thanks for reply
'KRISTEN'

kris

-- Check the current database.
DBCC CHECKDB;
GO

-- Check the AdventureWorks2008R2 database without nonclustered indexes.
DBCC CHECKDB (AdventureWorks2008R2, NOINDEX);
GO

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-11-29 : 03:48:25

quote:
Originally posted by antony_dba

how to execute the query DBCC CHECKDB whether we have to specify any database name

Open up Books Online (the help file that comes with SQL) and look up DBCC CheckDB.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources