Administration – Page 5 – LincolnBlog.net

* Checkpoints commit all dirty pages to disk. Therefore the very last checkpoint is the true starting point for SQL Server to start…

Here are a few SQL commands that you can use if you simply want to delete a database that is in “Recovering” or…

This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:

DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName);

1	DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName);

Views –…

Here is the SQL to display the last LSN applied to the database (think log-shipping)

SELECT
	redo_start_lsn
FROM sys.master_files
WHERE database_id = DB_ID('SecondaryDatabaseName')
AND type = 0

SELECT

redo_start_lsn

FROM sys.master_files

WHERE database_id = DB_ID('SecondaryDatabaseName')

AND type = 0

Views – 2824

Planned Relocation Procedure First, let’s get the information we will need to write the T-SQL script to alter the databases. Use the script…

Per the MSDN article below, accounts used to perform log-shipping tasks must be a member of the ‘sysadmin’ server role group: “The log-shipping…

Here is some simple T-SQL to enable or disable a SQL login account:

-- Disable the login 
ALTER LOGIN [someLogin] DISABLE
GO

-- Enable the login
ALTER LOGIN [someLogin] ENABLE
GO

-- Disable the login

ALTER LOGIN [someLogin] DISABLE

-- Enable the login

ALTER LOGIN [someLogin] ENABLE

Views – 1822

LincolnBlog.net