Administration – Page 3 – LincolnBlog.net

“Why can’t I truncate my log file?!?”

Posted on 03/07/201603/08/2016 by Lincoln Bovee'

I found a VERY useful query from Brent Ozar’s daily emails that go out on how you can check for the reason SQL…

Shrinking TempDB and what to do when it doesn’t

Posted on 02/04/201605/10/2016 by Lincoln Bovee'

This post is based on Tara’s recent blog post over on Brent Ozar’s site: and another: Basically, a query is killing your tempDB.…

Copy Logins to another server with SIDs and passwords

Posted on 02/01/201602/04/2016 by Lincoln Bovee'

I often need to replicate logins to another SQL Server where the SID and password (for SQL login types, not Windows based) need…

Viewing the remaining restore time for rebuilding log-shipping

Posted on 01/25/201601/27/2016 by Lincoln Bovee'

I sometimes need to rebuild the log-shipping for a database and if it is a large database the windows dialogs only display the…

Recycling SQL Server Error Logs without restarting the SQL service

Posted on 01/13/2016 by Lincoln Bovee'

You can recycle the SQL Error Logs without restarting the SQL service by using either of these 2 commands:

USE master;
GO

-- system sproc
EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command
DBCC ERRORLOG;

USE master;

-- system sproc

EXEC SP_CYCLE_ERRORLOG;

-- or

-- DBCC command

DBCC ERRORLOG;

Views – 1790

Switching from SIMPLE to FULL Recovery Model

Posted on 01/05/2016 by Lincoln Bovee'

Important to note: if you switch from SIMPLE recovery model to FULL, you will need to take a full backup, otherwise you are…

Error 4064 Return When User Connects via SSMS

Posted on 11/19/2015 by Lincoln Bovee'

USE master;
GO

SELECT	name, dbname
	FROM syslogins
	WHERE dbname = 'MyDatabase'
	ORDER BY dbname

SELECT	name AS LoginName, default_database_name
	FROM sys.server_principals
	WHERE default_database_name IS NOT NULL
	ORDER BY default_database_name

USE master;

SELECT name, dbname

FROM syslogins

WHERE dbname = 'MyDatabase'

ORDER BY dbname

SELECT name AS LoginName, default_database_name

FROM sys.server_principals

WHERE default_database_name IS NOT NULL

ORDER BY default_database_name

Views – 2005

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: Administration