sqlserver 2005 to 2008 [Resolved]

Posted by Kvenkat4025 under Sql Server on 5/24/2013 | Points: 10 | Views : 943 | Status : [Member] | Replies : 6
Hi,

I have database in 2005 with full of data , I would like to change these means sqlserver 2005 to 2008 with full of inserted data.

Please let me know the details

Thanks

K.Venkata

k.venkat


Responses

Posted by: Raj.Trivedi on: 6/18/2013 [Member] [MVP] Starter | Points: 50

Up
0
Down

Resolved
hello

may i know which version of sql 2008 u are using if it is a express version than it will not allow you to restore database if the size is greater than 4 gb,you will have to upgrade to sqlserver 2008 r2 which has 10 gb limit for restoring.

I hope it helps

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raj.Trivedi on: 5/24/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hello Venkat

Take a Back up of database that is SQL Server 2005

and

Restore it in SQL 2008

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rahmankhan on: 6/17/2013 [Member] Starter | Points: 25

Up
0
Down
Hi Venkat

take a back up of database and resotre

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kvenkat4025 on: 6/17/2013 [Member] Starter | Points: 25

Up
0
Down
yes ,i took backup .but it is not restoring in database.

am getting CREATE DATABASE AND ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit 4096 MB per database.

Thanks

K.Venkat

k.venkat

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kvenkat4025 on: 6/18/2013 [Member] Starter | Points: 25

Up
0
Down
thanks raj

k.venkat

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raj.Trivedi on: 6/18/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hello venkat

Has your issue resolved then you can mark it as answer or any doubt please post

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response