Renaming database after log shipping.

In order to move from one data center to another, I am planning to use log shipping.
Lets say,

Current Data center - DC1
Current Server- S1
Current Database- DB1

New Data Center -DC2
New Server -S2

Now, on the New Server S2, I already restored DB1 as DB1 for QA testing. QA has to do some testing before we move from DC1 to DC2. In the mean time, I need to start log shipping from S1 to S2, so that we can fail-over to S2. Now since DB1 database is already present on S2, I can not use the same name. I will have to use some other name (say DB1_New).
I can not wait for QA to finish their testing. I have to start log shipping before that. When QA is done, I will delete the DB1.

So for this log shipping, -

Primary - S1- DB1
Secondary - S2 DB1_New

So when we fail-over, we will have the database name as DB1_New. But all the apps use the name DB1. So I will have to rename the database as DB1.

So want to know, will this renaming the database (DB1_New to DB1) cause any issues?

Anyone had similar experience?

Thanks

Generally, you would be okay - some of that depends on how you have things configured, how long you are going to ship the logs before failing over to the other site, if logins/users have changed. You would want to consider what jobs you have running on the server, how this impacts your fail over plans and backups, anything pointing to the DB_new database name would need to be evaluated, etc. After the fail over and rename, you'd probably want to do a full backup of your databases, make sure the users are all intact, etc.

-Sue

|||

hi,

even if u have the same dbs in both source and detination prior to configuring log shipping, u need not create a new db in secondary instead u can drop the db in secondary......and while configuring log shipping u have the option to create the db @.destination if the db doesnt exist there already........if the failover is done properly all users from primary will be able to connect.....ensure that wherever u specified the db1 name in application change it to db1_new in your scenario........

rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LN
You can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
Jacco Schalkwijk
SQL Server MVP
"hlne" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>

rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LNYou can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
--
Jacco Schalkwijk
SQL Server MVP
"hélène" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>

rename table

Hello,
I want to rename a table but this table is used into storage procs and
views. How could I rename this table in order to the new name changes into
storage pros and views?
Thanks
LNYou can't, you will have to manually change the stored procedures and views.
You can however create a view with the same name as the old table that does
a straightforward select of all the relevant columns, that will save you
from having to update everything.
Jacco Schalkwijk
SQL Server MVP
"hlne" <Helene.Zouari@.isped.u-bordeaux2.fr> wrote in message
news:OIOxLRfsEHA.3788@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I want to rename a table but this table is used into storage procs and
> views. How could I rename this table in order to the new name changes into
> storage pros and views?
> Thanks
> LN
>sql

Removing MDAC

Hi!!!!
I need to remove the MDAC in order to remove ODBC drivers.
How can I do this?
I have Windows XP SP1 which comes with MDAC 2.7 but the third party
application installs an older version of MDAC (it seems to be MDAC 2.1) and
now another third party applicattion claims to install a MDAC 2.5 but this
application not update the MDAC. The installation process needs MDAC 2.1 be
removed.
How can I do this?
Thanks for any informationYou can change MDAC versions but you can't totally remove
MDAC on XP. I'm not sure what all you have done with your
current installation but try reinstalling the latest MDAC.
You can also use the component checker to check your MDAC
installation and version. You can download the recent MDAC
versions from:
http://msdn.microsoft.com/data/down...es/default.aspx
You can download the component checker from:
http://msdn.microsoft.com/data/down...ls/default.aspx
-Sue
On Fri, 27 Feb 2004 15:24:31 -0300, "The Desperate Newbie"
<desperate.newbie@.hotmail.com> wrote:

>Hi!!!!
>I need to remove the MDAC in order to remove ODBC drivers.
>How can I do this?
>I have Windows XP SP1 which comes with MDAC 2.7 but the third party
>application installs an older version of MDAC (it seems to be MDAC 2.1) and
>now another third party applicattion claims to install a MDAC 2.5 but this
>application not update the MDAC. The installation process needs MDAC 2.1 be
>removed.
>How can I do this?
>
>Thanks for any information
>