Cisco Cisco Unified MeetingPlace Audio Server Quick Setup Guide

The databases are logically linked; therefore, if you want to archive the detached MPWEB 
database, you must do the same for each MPWEB_XX database. If you want to reattach the 
MPWEB database to another SQL Server, you must also reattach the MPWEB_XX database(s). 

Enter exit to exit osql.

 in the 

 module

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

C:> osql -U sa -S SERVERNAME

Password: password

1>

1> use mpweb

2> go

In this example, the database MPWEB relies on two physical files: C:\MSSQL2K\Data\MPWEB.mdf 
and C:\MSSQL2K\Data\MPWEB.ldf.

1> sp_helpfile

2> go

name         fileid    filename                   filegroup size   maxsize  growth usage    

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

---------

MPWEBData             1 C:\MSSQL2K\Data\MPWEB.mdf   PRIMARY  

2432 KB Unlimited 1024 KB data only

MPWEBLog              2 C:\MSSQL2K\Data\MPWEB.ldf   NULL     

1280 KB Unlimited 10%    log only

1> use master

2> go

1> sp_detach_db 'MPWEB'

2> go