Veritas-bu

Re: [Veritas-bu] Restore of SQL2000 DB to SQL2005 server

2008-02-04 09:25:32
Subject: Re: [Veritas-bu] Restore of SQL2000 DB to SQL2005 server
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: "Jenner, Steven" <Steven.Jenner AT uk.telstra DOT com>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Mon, 4 Feb 2008 14:12:14 -0000
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: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Jenner, Steven
Sent: Monday, February 04, 2008 11:09 AM
To: veritas-bu AT mailman.eng.auburn DOT 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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>