(Msg. 1) Posted: Fri Nov 10, 2006 9:40 pm
Post subject: restoring SQL Server 2005 backup in sql server 2000 Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hi!
Can it is possible to restore backup of a database from sql server 2005
to sql server 2000 or i need to use DTS for this transformayion.
(Msg. 2) Posted: Sat Nov 11, 2006 8:50 am
Post subject: Re: restoring SQL Server 2005 backup in sql server 2000 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The format of the database files changed a bit in the file header in 2005. Because of this, 2000
cannot restore or attach 2005 backups/database files.
"Jami" wrote in message
>
> Hi!
> Can it is possible to restore backup of a database from sql server 2005
> to sql server 2000 or i need to use DTS for this transformayion.
>
> Regrads,
> Jami
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
(Msg. 3) Posted: Sun Nov 12, 2006 5:39 pm
Post subject: Re: restoring SQL Server 2005 backup in sql server 2000 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> Can it is possible to restore backup of a database from sql server 2005
> to sql server 2000 or i need to use DTS for this transformayion.
You cannot do it with BACKUP/RESTORE and I think you will have similar luck
with attach/detach. Far too many changes for backward compatibility to be a
feature here.
Restoring backup from earlier version of sql Server 2005 - Has any one ever heard of or had problems with restoring a backup from an earlier version of SQL SERVER 2005. For example: The backup is from a server version 9.0.2047. It is being rstored to a SQL Server 2005 version 9.0.3054. Is there any cause for..
How to transfer backup from client to server machine (SQL .. - In my line of bussiness it is not possible to help every client on this issue (several thousand users) What I need to achieve is transferring backup to the server by using SQL Server to do it and restoring it with SQL Server. A solution for SQL 2005 woul...
Can you edit the result set from Studio Manager Sql Server.. - Can you edit the result set from Studio Manager Sql Server 2005 like you could in EnterpriseManager sql server 2000? I loved being able to go directly into a table in sql server 2000 enterprise manager, return a result set and just edit inline right..
how to use sql server 2005 management tools to connect to .. - Hello, After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager. Regards, junior
Restore Sql Server 2005 db to Sql Server 2000 - I have a database that was backed up on a SQL Server 2005 system. Is it possible to restore the database to a SQL Server 2000 system?
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
