Home » Posts tagged 'DBA'
Tag Archives: DBA
Shrink the TempDB:
-- this command shrinks the primary data file
dbcc shrinkfile (tempdev, 'target size in MB')
-- this command shrinks the log file, look at the last paragraph.
dbcc shrinkfile (templog, 'target size in MB')
Shrink Log File:
DBCC SHRINKFILE ('Test_log',TRUNCATEONLY)
BACKUP LOG "Test DB Name" WITH TRUNCATE_ONLY
A select statement that returns the Version, Service Pack Level, and Edition information: (MS SQL 2000 and above)
SELECT @@VERSION as 'MS SQL', SERVERPROPERTY('productversion') as 'Version', SERVERPROPERTY ('productlevel') as 'Level', SERVERPROPERTY ('edition') as 'Edition'
For MS SQL 7.0 and earlier use:
See Microsoft Knowledge Base KB321185 for more information.
Unfortunately the Windows Internal Database (WID) that is default for things like WSUS, SharePoint Services 3.0 and other MS products and roles does not allow TCP/IP connections. In fact WID does not allow for remote connections at all. It does allow local Name Pipes though.