Home Forums Older Versions of SQL (v6.5, v6.0, v4.2) Older Versions of SQL (v6.5, v6.0, v4.2) How to restore a database in SQL 2005 from a backup copy in SQL 2000? RE: How to restore a database in SQL 2005 from a backup copy in SQL 2000?

  • June 1, 2012 at 2:19 pm

    #1496086

    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?