May 31, 2009 at 12:34 am
I am getting error while restoring the production database of 50 GB to my development server. SQL server is installed in C drive and data(data and log files) is located in a external hard disk of 320 GB. In my C drive 26 GB of space is free. While restoring this database I am getting this error :
"MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."
Please suggest solution or work around.
Thanks in advnace.
Manish
May 31, 2009 at 2:53 am
Stupid question, but is there enough space on the disk for the files you're trying to put there? It's possible that the restored database will be larger than the backup file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 2:57 am
Location of the database(i.e. portable hard disk) i am restoring has 290 GB free space. SQL sever is installed on C drive which has 25 gb.
May 31, 2009 at 3:09 am
Have you checked that the database is been restored to the large drive and not to C?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2009 at 5:45 am
Yes I have checked, database is stored in large drive.
May 31, 2009 at 6:01 am
Is 'tempdb' stored on the external drive as well?
May 31, 2009 at 6:06 am
How can i check it ?And if not then how can make tempdb to get stored in external drive
May 31, 2009 at 6:36 am
Check in the properties of the DB through M.S.
June 1, 2009 at 6:59 am
Are you doing the restore using Enterprise Manager or T-SQL in Query Analyser? If you are using EM can you run Profiler when you are doung the restore and post the T-SQL generated by EM? If using QA please post your T-SQL restore statement.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 1, 2009 at 9:48 am
I am using the query mentioned below:
RESTORE DATABASE [VIPA_APP] FROM DISK = N'D:\ASE-Downloads\VIPA\VIPA_APP' WITH FILE =
1, REPLACE,
STATS = 10
GO
June 1, 2009 at 9:59 am
Does the database VIPA_APP already exist on the destination server? If so, please run the following and post the results
exec sp_helpdb 'VIPA_APP'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2009 at 10:06 am
You probably need to use the MOVE clause to put the database on the external drive.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply