Re: msde backup

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

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 14:40:46 +0530

Hi,

There are 2 options:-

1. Perform a backup, copy the file to destination server and Restore the
database (no downtime)
2. Detach the database, copy MDF and LDF to destination, attach the database

I. Backup and Restore

1. Backup the database from OSQL from command prompt.

  c:\> OSQL -Usa -Ppassword -Sserver_name (enter)

  1>backup database dbname to disk='c:\backup\dbanme.bak' with init
  2>go

THis will backup the database to c:\backup folder

2. COpy the dbanme.bak to destination server

3. Restore the database using (RESTORE Database command) from OSQL

II. Detach / Attach

1. detach the database from source server

  c:\> OSQL -Usa -Ppassword -Sserver_name (enter)

  1>sp_detach_db <dbname>
  2>go

2. copy the MDF and LDF to destination server

3. Attach the database in source server (Use SP_ATTACH_DB procedure - refer
books online)

4.Attach the database in destination server (Use SP_ATTACH_DB procedure -
refer books online) 

--
Thanks
Hari
MCDBA
"steve" <anonymous@discussions.microsoft.com> wrote in message
news:20ce701c459c8$5d4b3e40$a501280a@phx.gbl...
> I use an application that stores all its information in an
> msde database and i would like to replicate the details in
> the live system to a backup system. Any idea which files i
> need to copy?

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)