ODBC SQLState:42000 while restoring database

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

ODBC SQLState:42000 while restoring database

Author

Topic

Cambodia
Starting Member

1 Post

Posted - 2006-02-16 : 04:44:35

Hello to all,

I have a problem with SQL server (persional edition) while I was restoring database and the error was that:

---------------------------------------------------------------------
Microsoft SQL-DMO (ODBC SQLState:42000) X
---------------------------------------------------------------------
MODIFY FILE encountered operating system error 112(There is not
enough space on the disk) while attempting to expand the physical file.
Could not create one or more files. Consider using the WITH MOVE
option to identify valid location.
RESTORE DATABASE is ternimating abnormally.

OK
---------------------------------------------------------------------

The space in my HD is OK, 10GB free. the database is about 5GB

Please help me ???

ollie098
Starting Member

1 Post

Posted - 2006-10-25 : 07:22:50

Try this:
Before restoring the database (let's say 5GB), you should have already created that database with a space allocation of 5GB.

In my case, I had created the database with the dafault values (2MB) and the same error message occured. After deleting that DB and creating a new and larger one, the restore worked

swamy428
Starting Member

1 Post

Posted - 2008-01-03 : 04:12:03

Hi,
I have aproblem with sql server 2000.
while restoring the database.its showing error as ODBC SQLSTATE:42000
cannot open backup device xxxxxxxxxxxxxxxxxx device error or device off-line.
RESTORE DATABASE is ternimating abnormally

Please help me?????
Thanks

donpolix
Yak Posting Veteran

97 Posts

Posted - 2008-01-03 : 12:50:49

run RESTORE FILELISTONLY FROM DISK = '..your backup file...'

The result shows you the locations of each data files. You should use WITH MOVE option on your RESTORE command so you can direct each file to a drive with enough free space.

Donn Policarpio

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-03 : 22:31:44

Should run 'restore verifyonly' in this case to ensure you have good backup file.

marcelene
Starting Member

1 Post

Posted - 2010-09-29 : 12:43:47

I am getting the same error 42000 error 112. The drive was full so I cleared 77G but the database is still loading but won't finish the restore. What should I do?

learnit
Starting Member

6 Posts

Posted - 2010-10-17 : 07:52:20

Couple of things before you try restore...
1.check for hidden files on the drive.
2.defragment the drive.
3.stop the antivirus running.
4. try the restore db <dbname> with move. check the books online for syntax.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-18 : 08:05:31

ummm, no. that's not going to help. the correct answer was already given over 2 years ago:

RESTORE VERIFYONLY

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources