Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Recovery Model Rss

Search for any content tagged recovery model

   Items 1 to 8 of 8   
 

Importance of Recovery Model in SQL Server

Have you ever wondered why the transaction log file grows bigger and bigger? What caused it to happen? How do you control it? How does the recovery model of a database control the growing size of the transaction log? Read on to learn the answers.  Read more...
By Additional Articles 2014/09/09 | Source: Database Journal | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 5,659 reads

Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...
By Additional Articles 2013/06/19 | Source: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 2,988 reads

Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell

Check if databases are really in FULL recovery model with a recovery model called pseudo-simple, where the database still behaves like it is still in SIMPLE recovery model until a full database backup is taken.   Read more...
By Additional Articles 2013/06/14 | Source: MSSQLTips.com | Category: recovery model
Rating: (not yet rated)  Rate this |   Briefcase | 150 reads

Working with SQL Server Recovery Models

The recovery models of SQL Server define how different backup and restore tasks will be performed on your database. When choosing a recovery model,   Read more...
By Prett Sons 2013/03/05 | Source: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 3,444 reads

An examination of bulk-logged recovery model

This article looks at the bulk-logged recovery model in depth and examines how it affects disaster recovery and logging.  Read more...
By Gail Shaw 2012/05/07 | Source: SQLServerCentral.com | Category: recovery model
Rating: |  Discuss |   Briefcase | 4,811 reads

Database recovery model change notification report for SQL Server

The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected.  Read more...
By Additional Articles 2011/11/02 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 1,961 reads

Recovery Models

Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.  Read more...
By Gail Shaw 2011/09/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,246 reads

How SQL Server recovery models impact your SharePoint ...

SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?  Read more...
By Additional Articles 2009/08/17 | Source: SearchSQLServer | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,214 reads
   Items 1 to 8 of 8