Solved

SQL Server 2008 DB convert to 2005 DB

Posted on 2013-10-29
2
348 Views
Last Modified: 2013-11-13
Hello,

I have a database that is compatible with SQL server 2008, how can I restore it over a SQL server 2005 database?
0
Comment
Question by:Matthew34
2 Comments
 
LVL 20

Assisted Solution

by:dsacker
dsacker earned 250 total points
ID: 39610004
Databases are upward compatible, not downward compatible. You can try the following link, but your chances of success are next to nil, and your effort will be substantial.

http://www.sqlservermart.com/HowTo/MSSQL_Convert_2008_To_2005.aspx
0
 
LVL 9

Accepted Solution

by:
COANetwork earned 250 total points
ID: 39610044
If you have both a 2008 and a 2005 system up at the same time, you can try to DTS data and objects from one DB to another.  It will be longer than a restore, and not every object can be transferred, though.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now