Backing up an MSDE Database?

Databases are located in the C:\MSSQL7\DATA directory with an *.mdf extension associated to a log file with a *.ldf extension.

What do you want to do?

  Backup the MSDE Database

 Backup the MSDE Database via the BACKUP Command

Backup the MSDE Database

To backup the msdb database, perform the following steps:

Note: use Uppercase characters if required in the following command lines, such as —U —P or —Q)

1. Select Start> All Programs> Accessories> Command Prompt to open a Command Prompt.

2. Enter the path C:\MSSQL7\BINN

3. Type the command: OSQL —U sa

4. Press ENTER.

5. Enter your Password.

6. Press ENTER. The following command line will appear:
   1>

7. Enter the command:
   1. backup database msdb to disk='c:\mssql7\backup\msdb.bak'

8. Press ENTER. The following command line will appear:
   2>

9. Enter the command:
   2. go

10. Press ENTER. A message will appear if the command is successful. The command line will go back to:
    1>

11. Enter the following command to quit:
    1. Exit

12. Press ENTER. The command line will go back to:
    C:\MSSQL7\BINN

Backup the MSDE Database via the BACKUP Command

To backup the MSDE Database via the BACKUP command, perform the following steps:

1. Select Start> All Programs> Accessories> Command Prompt to open a Command Prompt.

2. Enter OSQL —U sa —P "" —Q " backup database msdb to disk='c:\mssql7\backup\msdb.bak' "