Q
Problem solve Get help with specific problems with your technologies, process and projects.

Validating online backups

What can I do to validate an online backup (full) of a SQL Server database? I would like to do something like in Oracle; I'm using the parameter SHOW=Y, and I don't need to import anything. Only the file (export) is validated, without import the data.

You sure can, check out the

 RESTORE VERIFYONLY
command in SQL Server Books Online. This verifies the backup but doesn't actually restore anything.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close