Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvuyyuru9
Starting Member
2 Posts |
 Posted - 2013-03-19 : 02:30:17
|
| 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? mv |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2013-03-19 : 06:58:57
|
| 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. |
 |
|
|
mvuyyuru9
Starting Member
2 Posts |
Posted - 2013-03-19 : 08:24:10
|
| 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 advancemv |
|
|
|
|
|
|
sql 2000 db restoration problem