Cisco Cisco Unified MeetingPlace SMTP E-Mail Gateway Guida All'Installazione Rapida
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Detach and Attach the MPWEB SQL Database
18
Note
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).
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).
Step 14
Enter exit to exit osql.
Related Topics
•
•
in the
module
Examples: Detaching the Database
In the following examples, the output is displayed for each osql command that is used in the
Sample Output for Connecting to SQL Server
C:> osql -U sa -S SERVERNAME
Password: password
1>
Sample Output for Accessing the MPWEB Database
1> use mpweb
2> go
Sample Output for Displaying a List of Database Files
In this example, the database MPWEB relies on two physical files: C:\MSSQL2K\Data\MPWEB.mdf
and C:\MSSQL2K\Data\MPWEB.ldf.
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
Sample Output for Accessing the SQL Server Master Database
1> use master
2> go
Sample Output for Detaching the MPWEB Database
1> sp_detach_db 'MPWEB'
2> go