Solved

Can I verify a backup from the query window.

Posted on 2008-06-26
3
157 Views
Last Modified: 2010-04-21
I have a simple statement I am runniing:

backup database scan to disk ='c:\temp\backup.bak'

I know you can verify readabilty of a backup using the backup command from the context menu, but I wanted to know if there was a way to do this in a query window.

Thanks!
0
Comment
Question by:hyphenpipe
  • 2
3 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 21874496
You can use the RESTORE VERIFYONLY command to do this.
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 21874505
so, it would be something like this:

RESTORE VERIFYONLY FROM DISK = 'c:\pathtoyourbackup\backup.bak'
0
 
LVL 6

Author Closing Comment

by:hyphenpipe
ID: 31470957
Thanks!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Select * from 6 43
execute a MS SQL script as a schedule SQL job 72 137
SQL Express connecting form remote error 26 7 49
Getting max record but maybe not use Group BY 2 32
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question