Cant restore the database backup in SQL server 2005?

I wrote a sql like this to restore my database backup

use test
RESTORE DATABASE [Lorenzo]
FROM DISK = N'D:\Lorenzo'
WITH FILE = 1,
NOUNLOAD,
REPLACE,
STATS = 10
GO

But this is the error message that i am getting, but still i have 58.5GB free space in my hard drive ?

what is the wrongwith this SQL server 2005 ? i am using sql server 2005 standard edition !

===== Error=====
Msg 3257, Level 16, State 1, Line 2
There is insufficient free space on disk volume 'C:\' to create the database. The database requires 63689129984 additional free bytes, while only 54682599424 bytes are available.
Msg 3119, Level 16, State 4, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

any idea ! i am so stuck with this now !

thanks

regards

sujithf

Sujithf:

To me it looks like you don't have enough disk to cover the "nominal" size of the dtabase. You might have 58.5 GB freespace on the harddrive, but it looks like the database wants somewhere around 63GB. Do you have multiple drives on your server? If so, try allocating one of your files on an alternate drive. If not, see if you can purge some data off the drive.

Also, try to keep your database files off the OS drive whenever possible (and it looks like that is not possible in this case). In many cases in which I have needed space I have been able to migrate backups off to another disk or even to an external device. See if there are any old "large" backups that are clearly not needed.

Dave

|||

But my database backup size is just 5.11 GB ?

why is it need too many free space on c : drive to restore just 5.11 Gb size database ?

regards

sujithf

|||

Sujithf:

Again, this has to do with the "nominal" database size. If you have a pre-copy database with 70 GB and 69GB free space you are still going to need 70GB to restore the database. This is what I am calling the "nominal" size. Try shrinking your database. Often times you will have a large log file that can be shrunk and you also might be able to shrink your data file.

Dave

|||

thank you very much for u r profesional ideas Dave,

now i am going to shrink my database

my current allocated space is :60743.63 MB

avialable free space 1585.26 MP 2%

so what should i type for Maximum free space in files sfter shrinking ? ...........%

sujithf

|||

Well, this means that you require about 60GB of space. I don't think you are going to be do much of a shrink. If this is the case, I think you are going to have to scrounge to free up some space. Yikes!

Dave

|||

Yes dave i will allocate some free space in to my c drive by tomorrow

and again many thanks 4 u r information,cos i was so stuck diring this week to do this task,

now i know at least a solution for this matter

thanks to MSDN forum and Mr.dave

regards

sujith

|||You're welcome. :-)

Can''t install sql server 2005

Can't install sql server 2005

When I insert the disk autoplay flashes on the screen, then I get the message -
windows cannot open this file
splash.hta

I tried directly clicking several setup icons, but cancelled them because they didn't seem to be the initial setup of the server.

I've done this with both the dvd and the cds

dennist685

It worked with virtual-CD

This typically is an issue of a missing file association for the hta extension. To manually make the association, open Windows Explorer. From the Tools menu select Folder Options. From the Folder Options dialog select the File Types tab. Scroll down to see if there is an entry for HTA. Under File Types for HTA it should say "HTML Application". The associated information should be:

Action: Open
Application used to perform action: C:\WINDOWS\System32\mshta.exe "%1" %*
Use DDE: On
Application: mshta
Topic: System

Thanks,
Samuel Lester (MSFT)|||Thanks Samuel,

Can't say whether it'll work or not. I'm out for the morning, and won't be home until the late afternoon. Meantime I made the association on my laptop.

Hope it works. Thank you very much for the time you spent helping me. Somehow I still get the feeling I'll have to uninstall vs studio 2005, then reinstall beta2, then sqlserver beta2, then uninstall them. Which should I uninstall first. I want to make sure beta2 net framework beta 2.0 is there when I uninstall beta2.

dennist685|||

Did anybody get a solution on this. I am facing the same problem. I tried to open using windows explorer and it first throws javascript error and then it shows the Splash Screen on selecting install server components it throws a message saying. "Please go to Control panel to install and configure system components."

Any help is appreciated.

|||The message Rahul.Net reported is actually a different problem than what started this thread.

"Please go to Control panel to install and configure system components" is usually caused by having remnants of a previous SQL Server installation. This could be the same or an earlier version of SQL Server. It could even be a client only installation - and that is what can make it particularly difficult to troubleshoot. Any number of third party applications could install SQL client software to connect with a remote SQL Server. The presence of these items can confuse the SQL Server 2005 installer and prevent it from working. You may very well find yourself needing to uninstall third party software, install SQL Server 2005, then reinstall the third party software.

Can't install sql server 2005

Can't install sql server 2005

When I insert the disk autoplay flashes on the screen, then I get the message -
windows cannot open this file
splash.hta

I tried directly clicking several setup icons, but cancelled them because they didn't seem to be the initial setup of the server.

I've done this with both the dvd and the cds

dennist685

It worked with virtual-CD

This typically is an issue of a missing file association for the hta extension. To manually make the association, open Windows Explorer. From the Tools menu select Folder Options. From the Folder Options dialog select the File Types tab. Scroll down to see if there is an entry for HTA. Under File Types for HTA it should say "HTML Application". The associated information should be:

Action: Open
Application used to perform action: C:\WINDOWS\System32\mshta.exe "%1" %*
Use DDE: On
Application: mshta
Topic: System

Thanks,
Samuel Lester (MSFT)|||Thanks Samuel,

Can't say whether it'll work or not. I'm out for the morning, and won't be home until the late afternoon. Meantime I made the association on my laptop.

Hope it works. Thank you very much for the time you spent helping me. Somehow I still get the feeling I'll have to uninstall vs studio 2005, then reinstall beta2, then sqlserver beta2, then uninstall them. Which should I uninstall first. I want to make sure beta2 net framework beta 2.0 is there when I uninstall beta2.

dennist685|||

Did anybody get a solution on this. I am facing the same problem. I tried to open using windows explorer and it first throws javascript error and then it shows the Splash Screen on selecting install server components it throws a message saying. "Please go to Control panel to install and configure system components."

Any help is appreciated.

|||The message Rahul.Net reported is actually a different problem than what started this thread.

"Please go to Control panel to install and configure system components" is usually caused by having remnants of a previous SQL Server installation. This could be the same or an earlier version of SQL Server. It could even be a client only installation - and that is what can make it particularly difficult to troubleshoot. Any number of third party applications could install SQL client software to connect with a remote SQL Server. The presence of these items can confuse the SQL Server 2005 installer and prevent it from working. You may very well find yourself needing to uninstall third party software, install SQL Server 2005, then reinstall the third party software.

Can't install sql server 2005

Can't install sql server 2005

When I insert the disk autoplay flashes on the screen, then I get the message -
windows cannot open this file
splash.hta

I tried directly clicking several setup icons, but cancelled them because they didn't seem to be the initial setup of the server.

I've done this with both the dvd and the cds

dennist685

It worked with virtual-CD

This typically is an issue of a missing file association for the hta extension. To manually make the association, open Windows Explorer. From the Tools menu select Folder Options. From the Folder Options dialog select the File Types tab. Scroll down to see if there is an entry for HTA. Under File Types for HTA it should say "HTML Application". The associated information should be:

Action: Open
Application used to perform action: C:\WINDOWS\System32\mshta.exe "%1" %*
Use DDE: On
Application: mshta
Topic: System

Thanks,
Samuel Lester (MSFT)|||Thanks Samuel,

Can't say whether it'll work or not. I'm out for the morning, and won't be home until the late afternoon. Meantime I made the association on my laptop.

Hope it works. Thank you very much for the time you spent helping me. Somehow I still get the feeling I'll have to uninstall vs studio 2005, then reinstall beta2, then sqlserver beta2, then uninstall them. Which should I uninstall first. I want to make sure beta2 net framework beta 2.0 is there when I uninstall beta2.

dennist685|||

Did anybody get a solution on this. I am facing the same problem. I tried to open using windows explorer and it first throws javascript error and then it shows the Splash Screen on selecting install server components it throws a message saying. "Please go to Control panel to install and configure system components."

Any help is appreciated.

|||The message Rahul.Net reported is actually a different problem than what started this thread.

"Please go to Control panel to install and configure system components" is usually caused by having remnants of a previous SQL Server installation. This could be the same or an earlier version of SQL Server. It could even be a client only installation - and that is what can make it particularly difficult to troubleshoot. Any number of third party applications could install SQL client software to connect with a remote SQL Server. The presence of these items can confuse the SQL Server 2005 installer and prevent it from working. You may very well find yourself needing to uninstall third party software, install SQL Server 2005, then reinstall the third party software.

Can't install sql server 2005

Can't install sql server 2005

When I insert the disk autoplay flashes on the screen, then I get the message -
windows cannot open this file
splash.hta

I tried directly clicking several setup icons, but cancelled them because they didn't seem to be the initial setup of the server.

I've done this with both the dvd and the cds

dennist685

It worked with virtual-CD

This typically is an issue of a missing file association for the hta extension. To manually make the association, open Windows Explorer. From the Tools menu select Folder Options. From the Folder Options dialog select the File Types tab. Scroll down to see if there is an entry for HTA. Under File Types for HTA it should say "HTML Application". The associated information should be:

Action: Open
Application used to perform action: C:\WINDOWS\System32\mshta.exe "%1" %*
Use DDE: On
Application: mshta
Topic: System

Thanks,
Samuel Lester (MSFT)|||Thanks Samuel,

Can't say whether it'll work or not. I'm out for the morning, and won't be home until the late afternoon. Meantime I made the association on my laptop.

Hope it works. Thank you very much for the time you spent helping me. Somehow I still get the feeling I'll have to uninstall vs studio 2005, then reinstall beta2, then sqlserver beta2, then uninstall them. Which should I uninstall first. I want to make sure beta2 net framework beta 2.0 is there when I uninstall beta2.

dennist685|||

Did anybody get a solution on this. I am facing the same problem. I tried to open using windows explorer and it first throws javascript error and then it shows the Splash Screen on selecting install server components it throws a message saying. "Please go to Control panel to install and configure system components."

Any help is appreciated.

|||The message Rahul.Net reported is actually a different problem than what started this thread.

"Please go to Control panel to install and configure system components" is usually caused by having remnants of a previous SQL Server installation. This could be the same or an earlier version of SQL Server. It could even be a client only installation - and that is what can make it particularly difficult to troubleshoot. Any number of third party applications could install SQL client software to connect with a remote SQL Server. The presence of these items can confuse the SQL Server 2005 installer and prevent it from working. You may very well find yourself needing to uninstall third party software, install SQL Server 2005, then reinstall the third party software.

Cant get SQL Server Express to install

I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps herehttp://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.

Can anyone give me an idea of where to start?

Thanks

Try to install the version on msdn rather then on the CD and see if it works. Here is the link for the download.

http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

|||

Ha ha ha. Never quit.

Banging my head against the wall, or trying to get this thing to work?

I was thinking about my gov't issued perpetual virus scan, and thought I'd disable it. And then some time ago I had to do something (that never worked) regarding permissions to the INETPUB folder. And another source also suggested a direct download. Which is what I'll try next. I think I'll try it first in the 'repair' mode if it's available (as it is on the disk - it recognizes that the first three options installed properly and offers up the fourth).

|||

Success!

I had already disabled the virus scan, and so don't know if that had anything to do with it. But the download of just the SQL Server says it was successful. My dot net 2.0 framework was detected (it must be installed first), and it sailed thru like it should have in the first place.

As I think I mentioned in my first post, installation on my other laptop (wife's) with XP Home went perfect from the disk. A little weird that my old standby wouldn't work with it, but I'll accept it. And get started with what appears to be some very cool stuff.

|||I came across an issue on installing. When operating from the disk in the Visual Web Developer for Dummies book, the SQL Server just failed. No messages. When downloading from MicroSoft, I got a message that the c:\program files\microsoft sql server folder couldn't be compressed. So, while that message was up, I went thru explorer to change the properties of it. More than a few times, exe and dll files came up that were in use and couldn't be uncompressed. I finally hit the ignore all button and hoped for the best. When it was finished, I went back to the installation routine and hit continue. And it appears to have worked.