February 11, 2013 at 7:24 am
Hi All,
What are the step need to do decommission the database? Please explain me on this..
Satish
February 11, 2013 at 7:26 am
saidapurs (2/11/2013)
Hi All,What are the step need to Decommision the database? Please explain me on this..
Satish
What do you mean by decommission? Do you want to remove it from your system? Are you 100% certain it is no longer in use? If you can explain your question more clearly we can provide you a better answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 11, 2013 at 7:28 am
Can you give more information about why your decommisioning the DB and the steps already taken?
Perfom a full backup, offline the database, see who screams, if no one screams after X period of time, delete the database, but archive the full backup just in case its needed for anything inparticular in the future.
February 11, 2013 at 7:34 am
Hi Anthony,
Thanks for responding, even i doesn't no the meaning of decommission, some one asked me the same so i updated in forum.
Thanks for responce.
Satish
February 11, 2013 at 7:43 am
Might sound obvious - but I would go back to the person who asked you to decommission the database and ask them what they mean.
"There is no such thing as a dumb question.” ? Carl Sagan
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
February 11, 2013 at 7:55 am
Hi Stuart,
When i have put a comment on same he respond me, before you drop the database what all are the things you need to check, all details need to collect then only you can drop the database.
Satish
February 11, 2013 at 8:01 am
Logins and password
Jobs
SSIS Packages
Any cross database queries
Backup routines
etc, etc, etc
February 11, 2013 at 8:42 am
saidapurs (2/11/2013)
Hi Stuart,When i have put a comment on same he respond me, before you drop the database what all are the things you need to check, all details need to collect then only you can drop the database.
Satish
The list by Anthony is a very good start - but the whole answer will depend on your (or your senior DBAs) knowledge of the system.
To my mind only someone who knows a system and its potential interdependencies with others systems, reports, interfaces etc. can fill in the blanks. And that will have to come from within your company.
Having been through this recently (it was decided that we didn't need database xxx any more and a few systems didn't like it), I wouldn't make the choice lightly - but then again I might be paranoid.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
February 11, 2013 at 8:50 am
I'd monitor the server for a couple of days (to a couple of weeks if I could) to see if the database is being accessed. Then back it up. Then drop it and see who screams. If no screams after about 6 months, get rid of the backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply