September 13, 2004 at 4:32 pm
This question might have been asked before so please bear with me since im new at this.
On server 1, i have performed a backup from a user db and restored it to another user db in the same server with no problems or errors.
Why is it when i get the same sized backup from server 2, try to restore it on server 1, i get an error called Microsoft SQL-DMO (ODBC SQL State: 42000) with a message that says insufficient free space to create the database ?
September 13, 2004 at 7:07 pm
Does both the servers have same amount of free space ?
September 13, 2004 at 7:11 pm
No server 2 has bigger space. What are the size requirements when restoring?
September 13, 2004 at 8:01 pm
There isn't any additional space requirements, other than that to contain your database.
Is there a possibility that the data folders on both servers are different? If you restore a database from server 2 on server 1 without the MOVE options, SQL Server will by default try to restore it to the original folders as found on server 2, which may be non-existent on server 1 or do not have the required free space.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
September 14, 2004 at 3:08 am
As stated above if you store the database on server 1 on c:\ and then restore on server 2 without the move option then it will restore to the c:\ drive. Does the drive on server 2 which corresponds to server 1 have enough space?
September 14, 2004 at 8:37 am
Don't forget that the free space is included in the backup. The free space IS part of the database. This might be causing your problem. Try to shrink the database before backing it up and moving it.
-SQLBill
September 16, 2004 at 12:18 pm
Are there any repercussions to a Live database when shrinking?
September 17, 2004 at 8:44 am
One other thing....are you deleting the databases before restoring?
You say you have a database on Server 1, let's say it's 10GB. You backed it up and restored it to another user db on the same server (Server1). Now you have 20 GB of databases on Server 1. Then you take the same size database from Server 2 and try to put it on Server 1 - that's now 30 GB of databases.
How big are the databases and how much room do you have on the drive?
-SQLBill
September 17, 2004 at 10:59 am
They're not pretty big at all. The whole thing is probably 1 gig. The space on the drive is only 19 gigs. 11 gigs are being used.
September 20, 2004 at 3:21 pm
Ok i did it the other way around and it worked.
I think the space requirements in some of the references ive read are misleading. Requirement to backup from Device for a 1.2 gig database is 19 gigs??
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply