Cisco Cisco MeetingPlace Instant Messaging Anleitung Für Quick Setup
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