[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 _ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Restore of SQL2000 DB to SQL2005 server
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
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) [EMAIL PROTECTED] 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:* [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 -- Matthew MCP, MCSA, MCTS, OCA [EMAIL PROTECTED] Define Trouble: Why did you apply THAT patch?? ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu