Restore SQL 2000 db to SQL 2005

Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
Thanks in advance.
--
Vinni | www.Laksha.netVinni wrote:
> Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
> Thanks in advance.
> --
> Vinni | www.Laksha.net
Hi
IMHO no : you cannot restore a backup for SQL 2005 on SQL 2000 or SQL 7.
Try SQL Server Integration Services for transform data
regards
SW|||Vinni wrote:
> Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
> Thanks in advance.
> --
> Vinni | www.Laksha.net
No, you cannot restore a SQL 2005 database to SQL 2000. Your subject
indicates the opposite however. Which are you asking?
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Restore SQL 2000 db to SQL 2005

Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
Thanks in advance.
--
Vinni | www.Laksha.netVinni wrote:
> Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
> Thanks in advance.
> --
> Vinni | www.Laksha.net
Hi
IMHO no : you cannot restore a backup for SQL 2005 on SQL 2000 or SQL 7.
Try SQL Server Integration Services for transform data
regards
SW|||Vinni wrote:
> Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
> Thanks in advance.
> --
> Vinni | www.Laksha.net
No, you cannot restore a SQL 2005 database to SQL 2000. Your subject
indicates the opposite however. Which are you asking?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||I relised the mistake of incorrect subject line. Sorry about that.
What is "SQL Server Integration Services for transform data"?
--
Vinni | www.Laksha.net
"SW" wrote:
> Vinni wrote:
> > Is restoring a SQL Server 2005 backup file into SQL Server 2000 possible?
> >
> > Thanks in advance.
> > --
> > Vinni | www.Laksha.net
> Hi
> IMHO no : you cannot restore a backup for SQL 2005 on SQL 2000 or SQL 7.
> Try SQL Server Integration Services for transform data
> regards
> SW
>|||Hi, Vini,
Thanks for your response.
SQL Server Integration Service (SSIS) is a tool of SQL 2005 for data
transform between many kinds of data sources instead of DTS in SQL 2000.
You can create a SSIS project from SQL Server Business Intelligence Studio
under the menu of SQL Server 2005.
For the usage of SSIS, you may refer to SQL Server Books Online.
If you have any other questions or concerns, please don't hesitate to let
me know.
Have a good day!
++++++++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
++++++++++++++++++++++++++++++++
PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, a
nd confers no rights.
======================================================|||Hi Vinni,
Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.
Have a great day!
++++++++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
++++++++++++++++++++++++++++++++