Cisco Cisco Unified MeetingPlace Audio Server Quick Setup Guide

You must use the with move clause to successfully restore the database because the database 
backup file contains physical file locations that are not valid for this SQL Server installation.

Ensure that the operation was successful by reviewing the informational messages.

Repeat 

 and 

 for each slave database to restore the MPWEB_XX slave database files. 

Enter exit to exit osql.

In the following examples, the output is displayed for each command that is used in the 

C:> osql -U sa -S SERVERNAME

Password: password

1>

1> select name from sysdatabases where name = 'MPWEB'

2> go

name

-----------------------------------------------------

MPWEB

1>

1> drop database MPWEB

2> go

Deleting database file 'D:\MSSQLServer\Data\MPWEB.LDF'.

Deleting database file 'D:\MSSQLServer\Data\MPWEB.MDF'.

1>

In this example, the MPWEB database was exported from a MSDE 2000 server. The default ‘Data’ 
folder for this server is D:\MSSQLServer\Data, and the MPWEB database was created with one data file 
(logical name = ‘MPWEBData’, physical name = D:\MSSQLServer\Data\MPWEB.mdf) and one log file 
(logical name = ‘MPWEBLog’, physical name = D:\MSSQLServer\Data\MPWEB.ldf).

1> restore filelistonly from disk = 'C:\temp\mpweb.dat'

2> go

---------------------------------------------------

LogicalName PhysicalName            Type  FileGroupName Size          MaxSize              

----------- ------------------------ ------ ------------- --------------

---------------------

MPWEBData  D:\MSSQLServer\Data\MPWEB.mdf D     PRIMARY

    2490368.000000 35184372080640.000000

MPWEBLog   D:\MSSQLServer\Data\MPWEB.ldf L     NULL

    1310720.000000 35184372080640.000000