Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to restore a database in SQL 2005 from a backup copy in SQL 2000? Expand / Collapse
Author
Message
Posted Friday, June 1, 2012 10:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 12:41 PM
Points: 37, Visits: 8
Hi - I had a database in SQL 2000 and want to move it to SQL 2005. I made a backup copy in SQL 2000. When restoring it the SQL 2005, I receive message stating that it does not recognize the format. Any tips on this? Thanks.



Post #1309867
Posted Friday, June 1, 2012 11:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
Is this a native SQL backup from SQL Server 2000 you are trying to restore to SQL Server 2005?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1309896
Posted Friday, June 1, 2012 1:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 12:41 PM
Points: 37, Visits: 8
Yes, I use the SQL client tool (equivalent to SQL Server management Studio?) to make the backup. However, the backup file does not have an extention of ".bak" (it does in 2005/2008).



Post #1309947
Posted Friday, June 1, 2012 1:30 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,385, Visits: 36,828
Backup extension is irrelevant, you can just use the restore GUI to restore the DB, or RESTORE DATABASE T-SQL.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1309951
Posted Friday, June 1, 2012 2:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 12:41 PM
Points: 37, Visits: 8
Well, I use the studio UI to restore it - why 2005 does not recognize the 2000 backup file?



Post #1309983
Posted Friday, June 1, 2012 2:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:42 AM
Points: 20,799, Visits: 32,717
judyhou (6/1/2012)
Yes, I use the SQL client tool (equivalent to SQL Server management Studio?) to make the backup. However, the backup file does not have an extention of ".bak" (it does in 2005/2008).


What SQL client tool? Did it do the the backup or did it run a native SQL Server backup?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1309984
Posted Friday, June 1, 2012 2:26 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 40,385, Visits: 36,828
judyhou (6/1/2012)
Well, I use the studio UI to restore it - why 2005 does not recognize the 2000 backup file?


What do you mean by 'not recognise'?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1309988
Posted Wednesday, June 13, 2012 5:17 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:19 PM
Points: 121, Visits: 1,251
I am sure you are using correct method to Move SQL Server 2000 database to 2005. As you have shared that you are facing an error which says 2005 does not recognize the 2000 backup files, so I would like to recommend you to try another method to move SQL Server 2000 database to 2005. Here is the link:

http://twinklekumar.wordpress.com/2008/06/29/move-sql-server-2000-database-to-2005/


SQL Database Recovery Expert
Post #1315009
Posted Wednesday, November 19, 2014 1:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:10 PM
Points: 3, Visits: 1
If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database. Download help tool for sql database - SQL Server Restore Toolbox. http://www.sqlserver.restoretools.com/ You can read up more on SQL Server here. http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104
Post #1636476
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse