a little backup

Question

a little backup

forsqlserver

SSCoach

Points: 18902
More actions
March 4, 2009 at 10:00 pm

#201975

Dear All,
I have a running database bakup in sql server2005 around 30 GB and I want to check that whether that backup can be restored or not.
So I want to take a little backup and to restore on my local system so what Backup I should take? [less than 1 gb I can manage]
Thnx
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Your backup size will be much less than your db size.

A "little" backup is not possible in SQL. You could take file backups and restore them but i think thats not what you are looking at.

edit:- Look up RESTORE VERIFYONLY in BOL.

"Keep Trying"

forsqlserver SSCoach Points: 18902 More actions · Answer 2

My client says just check that whether that running back will restore any where or not,and to restore the 30 GB will take a long time,and the server I m using I have taken the remote desktop of that.

Actually in less time i want to do this activity

Thanks

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 3

As per almost all experts, this is what they all say..

The only way to ensure that you can restore the databases when you need to is by testing the backups. Testing them means more than simply verifying them. A proper test involves a test restore, which simply means restoring the database to a test or development server. Ideally, you should perform test restores monthly, at a minimum, and you should schedule them to run on a regular basis.

You can check RESTORE VERIFYONLY statement in BOL to get some details about verifying the back up.

-Roy

forsqlserver SSCoach Points: 18902 More actions · Answer 4

My client want to see the tables and stored procedures which will be restored from that little backup...help plase

Thanks

maechismo_8514 SSCoach Points: 17510 More actions · Answer 5

guptaajay1985 (3/5/2009)
My client want to see the tables and stored procedures which will be restored from that little backup...help plase

I don think that's possible without restoring the backup. The only options allowed on a backup are:

Verifying the backup file

Compressing the backup file

Moving the backup file

Restoring the backup file

None of the options above will satisfy your client needs. So restore it to a different server or check the original database where the backup was taken from.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 6

Doing the actual restore operation is the only sure shot way of confirming whether the backup will work or not?

You could compress the backup and save time if u need to move the backup to another server. Another easier way could be to restore the db to another (new) db on the same server. BE VERY CAREFULL about this if its a production server that you are working on. Your server will use up some resources for doing the restore and this can impact the server performance.

"Keep Trying"