Steve
Although I have never tried it, it should actually be possible within
SQL 2000 itself. Essentially, backup the DB using the SQL Backup tool
(in SQL2000) and then simply import (or restore) the DB into SQL 2005.
Im sure there is a wizard for this task.
Ive not actually tried it, but is there anything in the NetBackup DB
Admin Guide ?
Simon
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jenner,
Steven
Sent: Monday, February 04, 2008 11:09 AM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] Restore of SQL2000 DB to SQL2005 server
Hi, I have received a request to restore a DB which was backed up on a
SQL2000 client to a new server running SQL2005.
I know you can redirect a restore of a SQL DB to a different host but do
not know whether restoring to a different version of SQL is possible.
Has anyone done this and if so were there any issues?
Any information gratefully received.
The NetBackup environment is running on v5.1MP6.
Thanks in advance,
Steve.
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
This email (including any attachments) may contain confidential and/or
privileged information or information otherwise protected from disclosure.
If you are not the intended recipient, please notify the sender
immediately, do not copy this message or any attachments and do not use it
for any purpose or disclose its content to any person, but delete this
message and any attachments from your system. Astrium disclaims any and all
liability if this email transmission was virus corrupted, altered or
falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
REGISTERED OFFICE:-
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
