Link to home
Create AccountLog in
Avatar of bsharath
bsharathFlag for India

asked on

I have a 8Gb database which i attached to Sql 2008 and i have shrinked it.

Hi,

I have a 8Gb database which i attached to Sql 2008 and i have shrinked it.
And now i backed up and when try to restore in 2005 it does not work.

When i try to add the 8gb database to 2005 to shrink it does not allow and says above limit.

My goal is the database which is 8gb has to be restored to Sql 2005. Whats are the ways.

regards
raja
ASKER CERTIFIED SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of bsharath

ASKER

I have sql management studio 9.00.1399.00
is this it?
I get this

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'DEV8\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ok now with 2005 and express 2005 how can i get it loaded into 2005
Yep, all correct. Neither backup nor attach method will help because of the downgrade incompatibility issue. The only way to do that properly is by using the Copy Database wizard, but I don't think it is available with the Express Edition. Though it might be available on the 2008 side.
Where can i download a version where i can add the 8 Gb database .
2005 version
and can you please elain on copy database
Only the Express Edition is free. I could not find a 180-days offer (has been available earlier).

The Copy Database Wizard is available in your Mangement Studio, if you right-click on a particular database, choose "Tasks", then "Copy Database". Anything else should be straight-forward then.
Copy database i get this

TITLE: Copy Database Wizard
------------------------------

The destination server cannot be a SQL Server 2005 or later Express instance.

------------------------------
BUTTONS:

OK
------------------------------
>9.00.1399.00
The version of management studio is irrelevant, it's the SQL Server which handles the database files.

You indirectly gave the answer already:
>Restore failed for Server 'DEV8\SQLEXPRESS'

This means you're useing sql2005 express and cannot mount or restore 8gb. Even if sql2008 is able to reduce the logs and data to less than 4gb that shrinked database is incompatible with sql2005.

So why not stay in sql2008 once you're there with the database?

You are also able to use the shrinked version of the database with a sql2008 express installation, if the shrinked version is less than 4gb.

Bye, Olaf.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Raja obviously has to cope with sql2005 express and a sql2008 server (the latter perhaps a standard or even bigger "normal" sql server). So why add another sql server 2008 r2 express edition?

If the database is that big already it's only a question of time the transaction log will rise again, so why not move to a full sql server version and use the available sql2008?

Or is that also only an express edition?

Bye, Olaf.
Ok now to fix this issue i need to have Sql 2008 server right?
Can we install this in Windows XP?
Where Sql 2005 express is installed

Also does Sql express come in client and server
SQL Server always is a server, read the system requirements, yes, you can install sql server at client OS systems, not only the express versions.

But why do you need to install sql2008, you said you used it already. You then could also install sql2008 r2 express (r2 is important) to XP and move the database there. As acperkins correctly reminds me, this has a 10GB limit.

Bye, Olaf.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account