sqlserver 2005 to 2008 [Resolved]

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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

0	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

0	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

Latest Posts