Bookmark and Share
Last Updates
Display: 1 - 5 of 5, Total Pages: 1
1
[Work Notes] How to find SQL instance name, server name, DB status [Original] 2014-7-30 4:31pm
1. find instance name and server nameSELECT            SERVERPROPERTY('MachineName') AS [ServerName],         SERVE..

Read Full Article...

Section:MS SQL Server DBA | Read:612 | Comment:0 | Rating:0%

[Work Notes] How to find SQL Server Cluster Nodes and Shared Drives [Original] 2014-7-30 4:19pm
1. Find name of the Node on which SQL Server Instance is Currently running   SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [CurrentNodeName] ++ If the server is not cluster, then t..

Read Full Article...

Section:MS SQL Server DBA | Read:467 | Comment:0 | Rating:0%

[Work Notes] How to check SQL DB backup history [Original] 2014-7-30 4:15pm
Query 1SELECT s.database_name, s.server_name, s.machine_name,max(s.backup_start_date) as dateFROM msdb.dbo.backupset sgroup by s.database_name,s.server_name, s.machine_nameorder by dateQuery 2SELECT s..

Read Full Article...

Section:MS SQL Server DBA | Read:850 | Comment:0 | Rating:0%

[Work Notes] Change a SQL DB to read-only / read-write [Original] 2014-5-29 11:29am
-- Make Database Read OnlyUSE [master]GOALTER DATABASE [DBNAME] SET READ_ONLY WITH NO_WAITGO-- Make Database Read/WriteUSE [master]GOALTER DATABASE [DBNAME] SET READ_WRITE WITH NO_WAITGO -- Make Data..

Read Full Article...

Section:MS SQL Server DBA | Read:554 | Comment:0 | Rating:0%

[Work Notes] DBA tips: check size, log full, etc [Original] 2014-5-21 5:08pm
==check all databases' log file sizesDBCC SQLPERF(LOGSPACE);GO==check a table sizeUSE mbprod2;GOEXEC sp_spaceused N'dbo.htf43t_onstand_status';GO==check a database sizeUSE dbprod;GOEXEC sp_spaceused @..

Read Full Article...

Section:MS SQL Server DBA | Read:323 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am