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

You can "convert" a 2000DB to 2K5DB but that would be a job for the DBA (there is a wizard for this but keep a backup of the 2000 DB and restore to a new instance of the 2K5 using the conversion wizard). Where you restore the information is relative but this sounds like a database question more than a netbackup question.

On Feb 4, 2008 8:12 AM, WEAVER, Simon (external) <simon.weaver AT astrium.eads DOT net> wrote:

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

--
Matthew MCP, MCSA, MCTS, OCA
rascal1981 AT gmail DOT com

Define Trouble:
Why did you apply THAT patch??....

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu