SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Backup and restore Rss

   Items 1 to 20 of 71    Older >>
 

CDC and Restores

By Steve Jones 2018/03/23 | Category: change data capture (cdc)
Rating: (not yet rated) |  Discuss |   Briefcase | 698 reads

Restoring with CDC

By Steve Jones 2018/02/22 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 766 reads

PARTIAL Restores

By Steve Jones 2017/07/18 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 971 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2016/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,440 reads

Query Progress

By Muhammad Farhan 2016/01/27 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,583 reads

Complete Details About Backups Taken a Day Ago

Complete Details About Backups Taken a Day Ago.  Read more...
By S M 2016/10/20 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,440 reads

Trace Flag

By Vyas DCS 2014/10/30 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 1,657 reads

Compressed Backups

By Steve Jones 2014/06/13 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 1,568 reads

Backup and Housekeeping with Maintenance Plans

Get an idea of how to handle the housekeeping tasks associated with backups, like removing old backup and log files.  Read more...
By Gethyn Ellis 2014/02/17 (first published: 2011/01/26) | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 11,324 reads

An easy way to track the growth of your database

This query gives you an idea of the growth of your database over time.  Read more...
Rating: |  Discuss |   Briefcase | 14,301 reads

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...
By Philip Horan 2013/09/20 (first published: 2010/10/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,962 reads

Database Backup Restore

By Naseer Ahmad 2013/06/26 | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,535 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,508 reads

Restart Log Backups

By Steve Jones 2012/06/28 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,603 reads

Backups

By Stanley Kapfunde 2012/05/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,555 reads

Instant File Initialization and restores

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.  Read more...
By Johan Bijnens 2012/05/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,135 reads

Better Backups

By Steve Jones 2012/01/23 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,654 reads

Tail Log Backups

By Steve Jones 2012/01/13 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,154 reads

Backup Compression

By FOR SQLSERVER 2012/01/05 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,278 reads

Backing Up a SQL Server Database Directly Onto a Remote Server

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging server using RoboCopy  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,304 reads
   Items 1 to 20 of 71    Older >>
 
Tags
sql server 7 (16)    
configuring (8)    
miscellaneous (7)    
disaster recovery (dr) (5)    
replication (5)    
strategies (5)    
t-sql (5)    
indexing (4)    
dts (3)    
availability (2)    
backup (2)    
change data capture (cdc) (2)    
installation (2)    
monitoring (2)    
performance tuning (2)    
programming (2)    
restore (2)    
security (2)    
stored procedures (2)    
triggers (2)    
user defined function (udf) (2)    
ado (1)    
advanced querying (1)    
agent jobs (1)    
blogs (1)    
cleanup (1)    
compressed backup (1)    
copy_only (1)    
distributed queries (1)    
english query (1)    
error log (1)    
filegroups (1)    
instant file initialization (ifi) (1)    
kill (1)    
openxml (1)    
powershell (1)    
product reviews (1)    
recent backups (1)    
reviews (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server essentials (1)    
sql-dmo (1)    
striped backups (1)    
syntax check (1)    
trace flags (1)    
transaction log (1)    
updategrams (1)    
utility (1)    
video (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)