dbTalk Databases Forums  

SQL Server 2005 backup

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss SQL Server 2005 backup in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rogers
 
Posts: n/a

Default SQL Server 2005 backup - 03-27-2007 , 09:03 AM






Just wondering, If I take the SQL Server 2005 backup and can it be
restoreable in SQL Server 2000?



Reply With Quote
  #2  
Old   
Scott Morris
 
Posts: n/a

Default Re: SQL Server 2005 backup - 03-27-2007 , 10:04 AM






"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Quote:
Just wondering, If I take the SQL Server 2005 backup and can it be
restoreable in SQL Server 2000?
no




Reply With Quote
  #3  
Old   
Hari Prasad
 
Posts: n/a

Default Re: SQL Server 2005 backup - 03-27-2007 , 09:34 PM



Hello,

Due to architectural differences you can not RESTORE a SQL 2005 datbase into
SQL 2000 server. What you can do is create the database manually and use DTS
to transfer objects and data from SQL 2005 database to SQL 2000.


Thanks
Hari


"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Quote:
Just wondering, If I take the SQL Server 2005 backup and can it be
restoreable in SQL Server 2000?




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.