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

Qlemo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Olaf Doschke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bsharath

ASKER

I have sql management studio 9.00.1399.00
is this it?

bsharath

ASKER

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

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bsharath

ASKER

Ok now with 2005 and express 2005 how can i get it loaded into 2005

Qlemo

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.

bsharath

ASKER

Where can i download a version where i can add the 8 Gb database .
2005 version
and can you please elain on copy database

Qlemo

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.

bsharath

ASKER

Copy database i get this

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

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

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

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

Olaf Doschke

>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

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Olaf Doschke

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.

bsharath

ASKER

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

Olaf Doschke

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

Ramesh Babu Vavilla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial