EVA defragmentation.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

We have a HP EVA 5000. SQL 2000 Cluster is using 150 GB(Drive R:) on the EVA
for all database files. I want to defragment Drive R:. Fýrst I intend to
stop SQL Server and SQL Server Agent,then backup up all system and user
databases to Tape Backup(.mdf and .ldf files).Alternatively I may firstly
detach the user databases and then back them up. Next I will delete all user
database files from Drive R: and make sure no processes are accessing Drive
R:. Next I will run the defragmentation utility. Finally I will
restore(attach) the user databases. Are there any risks/pitfalls in my
action plan ?
What would be the best way to handle this matter ?

Best Regards.


.

Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Scheduling a Daily Backup of a SQL Database
    ... history for the job step usually has some more details. ... as if they are only set to SIMPLE you just need to backup the database. ... have found out how to backup ypur databases, you should be sure that you are ... SQL Server 2008 Standard for its database. ...
    (microsoft.public.sqlserver.server)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)