SQL Server with Mr. Denny:

Recovery Model

1

January 29, 2014  2:00 PM

Log Shipping Databases and Permissions Problems



Posted by: Denny Cherry
Attaching Database, Data Security, Database, Database Administration, Error 3013, Error 3119, Error 4319, Full Recovery Model, Log Shipping, Recovery Model, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Recently I was doing log shipping for a client in preparation to move their databases from one data center to another, when I was asked to change the drive that one of the target databases was being restored to. No problem, I'll just use ALTER DATABASE ... MODIFY FILE (name='xxx',...

December 3, 2013  6:15 PM

Upcoming SQL Saturday Precon in Albuquerque



Posted by: Denny Cherry
Clustered Index, Database, Database Administration, Database Design, Execution Plans, Indexing, Nonclustered Index, Recovery Model, SQL PASS, SQL Saturday, SQL Saturday 271, SQL Server

I'm very pleased to announce that I will be presenting a precon at the Albuquerque SQL Saturday at SQL Saturday 271 on...


August 14, 2013  2:00 PM

Back To Basics: Recovery Models



Posted by: Denny Cherry
Back To Basics, Recovery Model, SQL Server

The recovery models tell the SQL Server how much transaction log data to keep within the transaction log, and how much data recovery...


May 1, 2013  2:00 PM

I’m using simple recovery, so the log file isn’t important right?



Posted by: Denny Cherry
Bulk Logged Recovery Model, Database Administration, Full Recovery Model, Manageability, Recovery Model, Simple Recovery Model, SQL Server, Storage, Transaction Log

One of the big myths of SQL Server resolves around the transaction log, and how it's used with the simple recovery model. Many people think that...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: