Tuesday, March 20, 2012

Copying SQL 6.5 Database to SQL 2000

What is the easiest way to copy a 6.5 database to a SQL 2000 server? I've
tried to backup and restore with NetVault but it does not seem to work,
thought I'd done this in the past with Backup Exec but might be wrong. Is
there another way I can do this? Export and Import?
thanks
GavSeems that following postings can help you in resolving this issue:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?query=Restoring+SQL+6.5+to+SQL+2000&dg=microsoft.public.sqlserver.server&cat=en-us-technet-sqlserv&lang=en&cr=US&pt=261BA873-F3AB-420E-96D6-E3004596A551&catlist=328BAFD2-1A81-4558-B1DE-B6EB49F31B7E&dglist=&ptlist=&exp=&sloc=en-us
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?query=Restoring+SQL+Server+6.5+.DAT+file+to+SQL+2000&dg=microsoft.public.sqlserver.server&cat=en-us-technet-sqlserv&lang=en&cr=US&pt=261BA873-F3AB-420E-96D6-E3004596A551&catlist=328BAFD2-1A81-4558-B1DE-B6EB49F31B7E&dglist=&ptlist=&exp=&sloc=en-us
"Gav" wrote:
> What is the easiest way to copy a 6.5 database to a SQL 2000 server? I've
> tried to backup and restore with NetVault but it does not seem to work,
> thought I'd done this in the past with Backup Exec but might be wrong. Is
> there another way I can do this? Export and Import?
> thanks
> Gav
>
>

No comments:

Post a Comment