<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Backups
»
Unable to restore backup
11 posts, Page 1 of 2
1
2
»»
Unable to restore backup
Rate Topic
Display Mode
Topic Options
Author
Message
ALIF-662928
ALIF-662928
Posted Monday, May 12, 2008 1:09 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759,
Visits: 613
Hi all
unable to restore database
I have an test db, which needs to be restored with the latest backup, the problem is hard disk space, it was 43 gb free, but the latest bak file is 54gb, so in order to restore it i though of deleting the db and copying the latest bak file on it and restoring it.
Now the backup is there, and 58 Gb is free in the hard disk, But the prob is when im restoring is says
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'server1'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'D:\' to create the database. The database requires 76416024576 additional free bytes, while only 63008391168 bytes are available. (Microsoft.SqlServer.Smo)
i dont know whats the problem, i have 58 gb free space and 54 bak file then why its not restoring.
Pls let me know asap.
thanks
Post #499059
Gordon-265412
Gordon-265412
Posted Monday, May 12, 2008 1:14 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 07, 2013 5:45 PM
Points: 184,
Visits: 1,029
The backup file size is relevant only to the amount of data stored, not the amount of storage allocated to the databse.
You can have a 10MB backup file that restores to a 100MB database if the database has 100MB of space allocated when the backup was taken. The error is telling you that you need 76(ish)GB of free storage for the restore operation.
Your friendly
High-Tech Janitor
... :)
Post #499062
ALIF-662928
ALIF-662928
Posted Monday, May 12, 2008 1:22 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759,
Visits: 613
so what do i need to do, i dont have that much free space available.
Post #499070
Gordon-265412
Gordon-265412
Posted Monday, May 12, 2008 1:47 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 07, 2013 5:45 PM
Points: 184,
Visits: 1,029
Unfortunatly, there isn't anything to do other than find/make the freespace.
If the original database used multiple files, you have the option of restoring them to different physical drives.
Your friendly
High-Tech Janitor
... :)
Post #499096
ALIF-662928
ALIF-662928
Posted Monday, May 12, 2008 1:54 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759,
Visits: 613
can i delete the backup file on the local system and then restore it from the network drive, i know we can do this, but i dont know how to restore database from network,
Post #499101
Gordon-265412
Gordon-265412
Posted Monday, May 12, 2008 2:00 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 07, 2013 5:45 PM
Points: 184,
Visits: 1,029
Yes, you can restore it from the network. You'll need to ensure a couple things first though:
1: SQLAgent on the dbserver is using a domain account.
2: The domain account that SQLAgent is using has access to the network share/location.
Your friendly
High-Tech Janitor
... :)
Post #499107
Deepak-405225
Deepak-405225
Posted Monday, May 12, 2008 6:59 PM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, October 26, 2012 2:14 PM
Points: 402,
Visits: 598
The below command might work and will overwrite the existing database, ensure that Sql service account has permissions to that network drive. It might take some time and resource intensive.
Restore database dbname from disk='\\Network path name\filename.bak' With Replace
- Deepak
Post #499241
ALIF-662928
ALIF-662928
Posted Monday, May 12, 2008 8:05 PM
Right there with Babe
Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759,
Visits: 613
Thanks a lot guys, I am now able to do it through network. I was giving the path from the address bar from my computer, But now when i went into that path from run, It was different for example,
This is what i was giving in the path name:
//server1/w:/backups/MSSQL/Database.bak
When i enter the below path from run(Command Prompt), I found out just a simple mistake which i was ignoring.
//server1/backups/MSSQL/Database.bak
just see the difference in the backup paths on both ways, I think this will help some one else who can safe their time and frustration.
though the process is a bit slow in restoring, but its ok.
Thanks all again.
Post #499257
Gordon-265412
Gordon-265412
Posted Monday, May 12, 2008 9:24 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, March 07, 2013 5:45 PM
Points: 184,
Visits: 1,029
Nicole (5/12/2008)
Thanks a lot guys, I am now able to do it through network. I was giving the path from the address bar from my computer, But now when i went into that path from run, It was different for example,
This is what i was giving in the path name:
//server1/w:/backups/MSSQL/Database.bak
If the domain account for SQLAgent is a local admin on server1, you could have done: \\server1\w$\backups\MSSQL\Database.bak The $ denotes the default "Administrative" share for a drive.
When i enter the below path from run(Command Prompt), I found out just a simple mistake which i was ignoring.
//server1/backups/MSSQL/Database.bak
That's the proper way to use a UNC path (not as above using the w$, which requires local admin rights).
though the process is a bit slow in restoring, but its ok.
Thanks all again.
It can be a bit slow sometimes over the network. But at least you'll be able to get the database restored, and then run some shrink operations on it to get it back down to a manageable size. Sounds like there's some space to be reclaimed (if you're not going to be needing it).
You're quite welcome. :)
Your friendly
High-Tech Janitor
... :)
Post #499273
Minaz
Minaz
Posted Monday, May 12, 2008 9:36 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Sunday, April 21, 2013 10:57 PM
Points: 535,
Visits: 1,423
Gordon , I really appreciate the way you have helped Nicole and also us.
"More Green More Oxygen !! Plant a tree today"
Post #499277
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
