In our company we have decided to drop few databases , but we are not sure which application is being used ? which user is connecting ot working on it ?
So I have followed below steps to decide on dropping Database.
1.Running SQL Server Profiler Trace
Choose,Standard Default Trace:and ADD
1.Database name
2.HOSTNAME
3.NT DOMAIN NAME
4.Session Login name
5.Server Name
Also,
Choose database name Like:
% ABC%
%XYZ% and EXCLUDE Column which do not match
run the trace for few hours First and monitor the size of the files and then run for 24-48 hours.
If no connections found ?
2.OFFLINE the databases for a week
3.Backup the database and keep in separate folder(DO NOT DELETE)
4.DROP databases after notifying everyone....
No comments:
Post a Comment