July 28, 2010 at 9:12 pm
Please,
can you tell me if this is possible and how?
Restore a veritas online backup SQL 2000 IA64 db to a SQL 2005 x64 64 bits DB in another box???
thanks,
July 28, 2010 at 9:27 pm
Are you using the SQL Client with veritas or just the OS client?
If it is the SQL Client and if you have Veritas installed on the new server, then you should be able to do it through the veritas console.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 9:41 pm
basically i restore the online backup from ia64 to x64 -
are there any special steps for this? since when you open you will open on 2005 the db -
what happen with the logs from 2000 when you move to 2005 for the online backup you are restoring?
thanks,
July 28, 2010 at 10:05 pm
You would only want / need to restore the latest full backup. Thus when you are ready to restore the database to the new server, perform a full backup and then restore that backup to the new server. Once you restore the database, the database will be upgraded to SQL 2005.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 10:18 pm
we have only online backup - thats is all we have....
what you mean full backup - you mean the db must be offline - i must detach the db???
July 28, 2010 at 10:27 pm
No. A full backup is taken while the database is online. What is the recovery model of your database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 10:32 pm
i guess none, i am new in the site....the db has not had an offline backup in years....or be detach in years
they take online backups with veritas, and they restore it using veritas -
the prod db is in a ia64, i need to get a copy of prod for an application test
but i need to use one of those online backups on a x64 box, but i wil have to use 2005 to be 64..
any advice comment suggestion is welcome and very appreciated!
July 28, 2010 at 10:48 pm
There is no need to do an offline backup.
Are you doing transaction log backups?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 11:12 pm
yes they are doing every day....
by the way the does the restore must be set to norecovery
if i want to keep this db updated with information from 2000 after the restore....
should i do log shipping from the 2000 to the 2005 using norecovery ?
what will happen if my qa users do changes on the appl?
Thanks,
July 28, 2010 at 11:14 pm
Are you trying to setup log shipping from the 2000 database to the 2005 database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 11:17 pm
yes! i would like that because i need the sever updated for 2 months everyday!
another question.....what happens if you just have os client?
July 28, 2010 at 11:25 pm
Log shipping between the two is not possible.
http://blogs.msdn.com/b/sanchan/archive/2006/02/12/530651.aspx
If you want to setup something to do a daily update between the two servers, I recommend an alternative process. You can do a daily full backup from the source and restore on the destination server.
I recommend also that you do a little reading on recovery model types. BOL would be a good source for that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 11:29 pm
the problem is the db is more than 2 T
:(:(
July 28, 2010 at 11:37 pm
Do you need the entire database?
Is this to go from production down to a QA environment?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 28, 2010 at 11:41 pm
yes, I need the full db,
yes it will go to PROD for QA.
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply