Re: Possible to use DB created in SQLServer2005 in SQLServer2000 ?
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Tue, 13 Mar 2007 20:00:57 -0600
No. You can't restore a SQL Server 2005 backup to SQL Server 2000 and
you can't use detach/attach.
-Sue
On Wed, 14 Mar 2007 11:30:23 +1100, "Stephen Ahn" <noaddress> wrote:
Here's what we are trying to do :
1) Create a new databse in SQLServer2005, use that database under
SQLServer2005.
2) about a month later, that database is backed up and sent to another site,
which is using SQLServer2000.
3) We want to restore this database at the SQLServer2000 site, and start
using it.
Is step 3) possible ? if so, any gotchas (eg. any special considerations).
TIA,
Stephen
.
- References:
- Possible to use DB created in SQLServer2005 in SQLServer2000 ?
- From: Stephen Ahn
- Possible to use DB created in SQLServer2005 in SQLServer2000 ?
- Prev by Date: Possible to use DB created in SQLServer2005 in SQLServer2000 ?
- Next by Date: SQL Exoress 2005 Hardware Requirements . . .
- Previous by thread: Possible to use DB created in SQLServer2005 in SQLServer2000 ?
- Next by thread: SQL Exoress 2005 Hardware Requirements . . .
- Index(es):
Relevant Pages
|