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

Content with tags Backup / Restore, Administration Rss

   Items 1 to 20 of 54    Older >>
 

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 / restore
Rating: |  Discuss |   Briefcase | 11,164 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...
By Sylvia Moestl Vasilik 2013/11/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 14,194 reads

Database Backup Restore

By Naseer Ahmad 2013/06/26 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,407 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,492 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: backup / recovery
Rating: |  Discuss |   Briefcase | 4,056 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...
By Additional Articles 2011/12/22 | Source: SQL Server Performance | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,996 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,512 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,154 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...
By Sylvia Moestl Vasilik 2013/11/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 14,194 reads

Backup all databases & check backups

Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups  Read more...
By Pavle-192195 2011/05/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,731 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By Sourav Mukherjee 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,340 reads

Restoring after TRUNCATE TABLE

By Duncan Pryde 2011/03/09 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,962 reads

Default Backup Directory

By Duncan Pryde 2011/02/23 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,576 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 / restore
Rating: |  Discuss |   Briefcase | 11,164 reads

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.   Read more...
By Bharat Panthee 2011/01/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,963 reads

Backup Report

A handy script for DBAs to find the last healthy backup of a database.  Read more...
By Vijendran R 2010/11/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,727 reads

Setting SQL Server Default Locations

How to set the default locations for backups, data files, and log files in SQL Server.  Read more...
By Wayne Sheffield 2010/11/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 5,459 reads

Backup all Filegroups

A short script to backup all filegroups, for those who utilise filegroups within a database.  Read more...
By Richard Doering 2011/06/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,154 reads

Statistical Sampling for Verifying Database Backups

A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.   Read more...
By Additional Articles 2010/06/01 | Source: SimpleTalk | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,315 reads

Transaction Log Growth, do you need it?

One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.  Read more...
By James Rea 2010/05/28 (first published: 2009/01/05) | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 32,227 reads
   Items 1 to 20 of 54    Older >>
 
Tags
sql server 7 (16)    
configuring (8)    
miscellaneous (7)    
replication (5)    
strategies (5)    
t-sql (5)    
disaster recovery (dr) (4)    
indexing (4)    
dts (3)    
availability (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)    
backup / recovery (1)    
blogs (1)    
cleanup (1)    
copy_only (1)    
distributed queries (1)    
english query (1)    
errorlogs (1)    
filegroups (1)    
instant file initialization (1)    
jobs (1)    
kill (1)    
openxml (1)    
powershell (1)    
product reviews (1)    
recent backups (1)    
reviews (1)    
sql server 2005 (1)    
sql-dmo (1)    
striped backups (1)    
syntax check (1)    
transaction logs (1)    
updategrams (1)    
utility (1)    
video (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)