FW: Toad-SS 5.5 caching problem with database USE when dropping and restoring a database. [1 Attachment]

[ Attachment(s) from Hank_Freeman (MSN) included below]

Toad-SS 5.5 failing to update cache or something like this...

Attachment(s) from Hank_Freeman (MSN)

1 of 1 File(s)

ToadSupportBundleToad for SQL Server.zip

image001.gif

image002.jpeg

Hank,

Can you please clarify:
image002.jpeg

Hank,

Can you please clarify:
image001.gif

Hank,

Can you please clarify:
image001.jpeg

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.jpeg

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif

Sorry wrong Case number … Please remove the below comments from 950847

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

Sorry wrong Case number … Please remove the below comments from 950847

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.jpeg

Sorry wrong Case number … Please remove the below comments from 950847

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif

Corrected Case ID !!!

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)

Corrected Case ID !!!

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif

Corrected Case ID !!!

See Answers below !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg

To all:

I just went through the whole process again and this time it failed after I had
created the database from the restore. Please notice that the HF_RCMA is
different from the previously reported database name for the RCMA and RGCMA

Meaning this is slightly different when I ran the same script with only database
name changes.

I have preserved the backup so it can be used by support if needed.

When needed I will get with Gita, about putting it on the ftp site, where I have
a login.

Hank Freeman

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

To all:

I just went through the whole process again and this time it failed after I had
created the database from the restore. Please notice that the HF_RCMA is
different from the previously reported database name for the RCMA and RGCMA

Meaning this is slightly different when I ran the same script with only database
name changes.

I have preserved the backup so it can be used by support if needed.

When needed I will get with Gita, about putting it on the ftp site, where I have
a login.

Hank Freeman

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image001.jpeg

To all:

I just went through the whole process again and this time it failed after I had
created the database from the restore. Please notice that the HF_RCMA is
different from the previously reported database name for the RCMA and RGCMA

Meaning this is slightly different when I ran the same script with only database
name changes.

I have preserved the backup so it can be used by support if needed.

When needed I will get with Gita, about putting it on the ftp site, where I have
a login.

Hank Freeman

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image001.gif

To all:

I just went through the whole process again and this time it failed after I had
created the database from the restore. Please notice that the HF_RCMA is
different from the previously reported database name for the RCMA and RGCMA

Meaning this is slightly different when I ran the same script with only database
name changes.

I have preserved the backup so it can be used by support if needed.

When needed I will get with Gita, about putting it on the ftp site, where I have
a login.

Hank Freeman

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image002.jpeg