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 2000 Forums
 SQL Server Administration (2000)
 Database cleanup

Author  Topic 

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-01-22 : 10:13:52
what usually commands or scripts will be used for the database cleanup.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 10:21:03
You mean something like this?

DROP DATABASE <YourDatabaseNameHere>

On what level do you refer "cleanup"?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-01-22 : 10:40:58
Like Dbcc reindex etc..
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-22 : 10:42:58
quote:
Originally posted by Peso

You mean something like this?

DROP DATABASE <YourDatabaseNameHere>

On what level do you refer "cleanup"?


Peter Larsson
Helsingborg, Sweden



The database will be really 'clean'


KH

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 10:43:36
You mean a complete maintenance run?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-22 : 14:33:23
quote:
Originally posted by sqldba2k6

what usually commands or scripts will be used for the database cleanup.


Usually, it will be the commands and scripts that you write to do the cleanup.



CODO ERGO SUM
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-01-23 : 02:46:37
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Houskeeping

Kristen
Go to Top of Page
   

- Advertisement -