473,287 Members | 1,560 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Verify backup after the backup is completed

I have a database backup that our vendor proformed. I dont know if
they verified the backup, nor do I have the disk space to create a new
backup with verify or retore the current backup.

Is there a t-sql command that I can use to verify the database backup
after the fact?
SQL Server 2000 currenlty patched
The backup of the database is a 97GB file on the server in question.
TIA
Rob
Oct 23 '08 #1
1 6239
rcamarda (ro**************@gmail.com) writes:
I have a database backup that our vendor proformed. I dont know if
they verified the backup, nor do I have the disk space to create a new
backup with verify or retore the current backup.

Is there a t-sql command that I can use to verify the database backup
after the fact?
SQL Server 2000 currenlty patched
The backup of the database is a 97GB file on the server in question.
The you need to see your local hardware vendor and get disk onto
which you can restore this backup. That's the only way you can verify
it properly. A 250 GB disk is dirt cheap these days. Since this is for
verification only, you can even do this with a USB disk.

There is a command RESTORE VERIFYONLY, but as Books Online says:

Verifies the backup but does not restore the backup. Checks to see that
the backup set is complete and that all volumes are readable. However,
RESTORE VERIFYONLY does not attempt to verify the structure of the data
contained in the backup volumes. If the backup is valid, Microsoft® SQL
Server™ 2000 returns the message: "The backup set is valid."

And unless this is a read-only database, you should probably take
backups yourself as well.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Oct 23 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: jwbeaty | last post by:
Here's a weird one. I'm running SQL Server 7 and when I run a backup something weird happens. When I perform the backup via Enterprise Manager by right clicking on the database I want to...
6
by: tgru | last post by:
Hello, Can anyone tell me how to backup read-only databases? I want to backup the secondary databases in my log shipping pairs. Thanks, TGru *** Sent via Developersdex...
3
by: ChrisWinterscheid | last post by:
We are running DB2 8.1 on AIX 5.2. DB2level shows: DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016" with level identifier "02070106". Informational tokens are "DB2...
14
by: johnm | last post by:
Hello All, I appreciate all of the help with my previous posts. It's nice having such a knowledgeable group to draw upon for help. I have taken all of your previous suggestions to heart and...
3
by: t2581 | last post by:
Hi , I run restore with rollforward In job in output, last commited transaction time less then backup image time Is it normal ? RESTORE DATABASE PRICE_V8 FROM "E:\BACKUP" TAKEN AT...
1
by: Najm | last post by:
Hi All, I am facing this issue very frist time. I add a logical device as following: USE master GO EXEC sp_addumpdevice 'disk', 'AdvWorksData',
0
by: Massimiliano Campagnoli | last post by:
Can you explain me what is going on here ? J:\ is a network drive located on a samba server. DB2 is V7.2 fixpak 14. net use j: \\linuxserver\backupdb2 The command completed successfully. ...
0
by: Massimiliano Campagnoli | last post by:
I am trying to backup sample database to network drive J:\ which maps to a SAMBA share. The first time the backup is successfull but the the next time fails. I've to delete J:\sample.0 if I want...
2
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.