I have sql server 2000 database scheduled to automatic backup every 1 hour to d:\ drive. Recently I formatted my boot partition c:I installed sql server 2000 and started restoring from the backup. The actual data is about 40 MB. The backup file shows 215 GB. When I tried to restore, it only shows data till 9 months back. But backup file's date modified shows correctly to one day prior to format. I don't have any other data file other than this backup file. Can anybody help me?
I would assume you have been appending evry day and that when you load the backup, you will have a load of sets in the backup, once you choose one, it will be the size you expect. I think you are going to need to find the space to load this in the first place though as I assume thats the issue.
thnks for immediate reply. I even tried that way too. I tried with a new hard disk 300 GB with single partition, installed OS, SQL server 2000, restored the 215 GB backup file. but no use. it showed till data 9 months back. The backup file's Date modified property shows 13th March,2013 with time. But It did not restore completely. any ideas? thnks in advance