Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Friday, 31 January 2014

Reduce Shareweddb_log file size

Use SQL Management Studio & connect to ##SSEE database

Choose the ShareWebDB

New query & run below to reduce log file size

USE ShareWebDb
 GO
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 BACKUP LOG ShareWebDb WITH TRUNCATE_ONLY
 DBCC SHRINKFILE(ShareWebDb_log, 1)
 GO

Wednesday, 22 January 2014

Connecting to the Windows Internal Database (MICROSOFT##SSEE)

Using SQL Management Studio

The server name to connect to is 
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query