Issue after dropping databases

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Issue after dropping databases

Author

Topic

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-08-12 : 10:24:24

Hi Gurus,

I want to drop one database and repliction related to this datadase.

After dropping i want to check as no objects in other databases and server is refreing this droped database.

How can i check this.

I am trying to check this by running trace with Texttype as database name as column filters.

Please let me know if i am going in right way.

If not please correct me..

Thanks,
ServerTeam

Sundaresan
Starting Member

28 Posts

Posted - 2008-08-12 : 10:53:05

Hi,

Before u drop a database which is replicated, drop all the publication and subscriptions corresponding to it.

If the replication is dropped the hand symbol will not be present.
Then u can drop the database.

Also before dropping replication u need to take the list of tables that are replicated and then drop the publication, article and subscription

Sundaresan.R

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-08-12 : 14:06:41

This is fine in case of replication.

But how can i check as this database is not used as reference in any object.

I mean to say as in cross servers.

Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-12 : 14:13:40

Only I think is to track with SQL profiler before you drop
Or use third party tools to find cross-server as well:
http://www.red-gate.com/products/sql_dependency_tracker/index.htm

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-08-12 : 14:29:45

Already dropped database.(Took Offline)

Now i am in testing process.

Now how can i proceed.

Thanks,
ServerTeam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-12 : 14:33:06

quote:
Originally posted by ServerTeam

Already dropped database.(Took Offline)

Now i am in testing process.

Now how can i proceed.

Thanks,
ServerTeam

How can you proceed when database is offline? Wait for some time to see somebody is on top of your head.

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-08-12 : 14:40:04

Is there a way to run profiler and check.
If so can you please post me the events that i need to check..

Thanks,
ServerTeam

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-08-12 : 14:40:08

Is there a way to run profiler and check.
If so can you please post me the events that i need to check..

Thanks,
ServerTeam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-12 : 14:41:56

quote:
Originally posted by ServerTeam

Is there a way to run profiler and check.
If so can you please post me the events that i need to check..

Thanks,
ServerTeam

How will you run profiler once you dropped your db?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-12 : 23:07:57

>> Is there a way to run profiler and check.

Wait to see if any app complains.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources