March 5, 2009 at 3:27 pm
Hello comunity
I have this 2 following questions:
1-Could i install SQL Server 2008 Express on same pc with SQL server 2005 STD, of cause in another instance.
2- Suppose my databases clients works all on SQL Server 2005 STD or EXPRESS.
2.0 - SQL server 2008 databases are compatible with SQl Server 2005 ?
2.1- if i use SQL Server 2008 Express to logged on theses clients databases, can i cause any problems on them ?
2.2 - If i restore a client database that use SQL SERVER 2005 , on my SQL SERVER 2008 and after that i reattach this database on SQL Server 2005, the same one works without problem ?
This question is because i want to begin use SQl Server 2008.~
Many thanks
Best regards
Luis Santos
March 5, 2009 at 3:47 pm
1.Yes should not be an issue.
2.0, you can look at SQL Server 2005 databases using SQL Server 2008 tools. But other I don't think is possible.
2.1, shouldn't I am always using SQL 2005 tools on 2000 and am using SQL 2008 sometimes on 2005 without issues.
2.2, No you can't. If the database has been attached to 2008 it cannot be attached back to 2005.
.. Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 6, 2009 at 5:37 am
Hello Mohit
Thanks for your reply,
on point
2.2 - No you can't. If the database has been attached to 2008 it cannot be attached back to 2005.
I think that if i make a backup through SQL 2005 and i restore the same on SQL 2008, ok it´s not possible.
But if i dettach the sql 2005 database and attach then on SQL2008, and after this, i make the opposite, i think that have no problems, or SQL 2008 make some changes on the structure ??
Best regards
Luis Santos
March 6, 2009 at 7:26 am
You cannot move a SQL Server database to any new version and take it back to the old version because the new and the old are not the same. So you cannot move either 2000 or 2005 to 2008 and move it back to either 2000 or 2005. I hope this makes it very clear.
Kind regards,
Gift Peddie
March 6, 2009 at 8:28 am
luissantos (3/6/2009)
Hello MohitThanks for your reply,
on point
2.2 - No you can't. If the database has been attached to 2008 it cannot be attached back to 2005.
I think that if i make a backup through SQL 2005 and i restore the same on SQL 2008, ok it´s not possible.
But if i dettach the sql 2005 database and attach then on SQL2008, and after this, i make the opposite, i think that have no problems, or SQL 2008 make some changes on the structure ??
Best regards
Luis Santos
As Gift said it is not possible; and you are correct as you attach the database of an older version of SQL Server to the newer one the meta data information gets updated. So it cannot be reattached to the older versions.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply