Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting error while Restoring the Sql Server Database
Message
From
21/01/2007 01:19:11
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Getting error while Restoring the Sql Server Database
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01187479
Message ID:
01187479
Views:
74
Dear Experts,
When i m trying restore databse from backup,Using SQL server 2005.
i got an error message like this

MODIFY FILE encountered operating system error 112 (There is not enough space on the disk.) to expand the physical file.
RESTORE DATABASE is terminating abnormally

The size of Backup file is 800MB and 9.00 GB is free in Drive C:.
(Note : I have seen that The original siz of Mdf is 800 MB and the size of Log file 9.2 GB)

Can anybody help me to sovle this issue.
I have one more doubts
Since the size of Log file is 9.2 GB, How the backup file size become 800 MB ?

With thanks and regards
Abdulla
Reply
Map
View

Click here to load this message in the networking platform