Re: Server Rebuild - What to do?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Raj,

That will work, but as a backup procedure perform a full database backup for
all databases including system databases before you do any thing.

Steps:-

1. Do a full database backup all databases and keep in a safe place
2. Stop SQL Server service
3. COpy the MDF and LDF to a safe location including system databases
4. Install OS
5. Install SQL Server in same path
6. Apply the same service packs
7. Stop SQL Server service
8. COpy the MDF and LDF files to right path including system database files
9. Start SQL Server

This will definetely work out. Incase if it gives issues then use the
backups taken in step-1

Thanks
Hari



"raj" <raj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D66D8D12-06F3-4848-9B62-856AE2DA7974@xxxxxxxxxxxxxxxx
We are planning to Rebuild our production server. It has SQL Server 2000
Database and has the Clustered Setup in it and we have Windows 2003
Server.
As there is some problem in the setup done in the machine we are planning
do
the fresh build by installing OS freshly and also install SQL Server 2000
Enterprise Edition. What I want to know is that how can we bring the
production database intact with the current setup post rebuild?

Can we copy the existing .MDF and .LDF files for all the system databases
(Master, MSDB and Model) and user databases and post rebuild stop the SQL
Server services and copy the .MDF and .LDF files from the backup that we
haven prior to the build? Is it the right way to bring back the
production
system by using this method?


.

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)