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

Content with tags administration, backup / restore Rss

<< Newer    Items 21 to 40 of 54    Older >>
 

Perform a Striped Backup

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...  Read more...
By Bru Medishetty 2009/12/16 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

Custom cleanup procedure for backup files

There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.   Read more...
By Roshan Joe Joseph 2009/11/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,428 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

Script to find latest backups for all databases

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.  Read more...
By Roshan Joe Joseph 2009/07/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,241 reads

How to find out how long a SQL Server backup took

Many shops do full backups of their databases as part of a job within SQL Agent, typically as part of a maintenance plan. This job will often times do all database backups in secession. As such, while you may know how long the job takes, you may not know how long any one particular database takes to have a full backup taken.   Read more...
By Additional Articles 2009/05/22 | Source: MSSQLTips.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,351 reads

Check Syntax on a Database

This script finds the first error on all Sprocs, Functions, Triggers and Views in a database. Works in SQL Server 2005 and 2008  Read more...
By Stephen Schaff 2009/04/21 | Source: SQLServerCentral.com | Category: syntax check
Rating: |  Discuss |   Briefcase | 870 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

Generate CREATE DATABASE FOR ATTACH for all databases on server

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.  Read more...
By Wesley Brown 2008/12/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,240 reads

Create Backups without Breaking the Database Backup Sequence

This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence  Read more...
By Additional Articles 2008/12/18 | Source: SQL Server Performance | Category: backup / restore
Rating:  Rate this |   Briefcase | 2,862 reads

Changing the default SQL Server backup folder

Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?  Read more...
By Additional Articles 2008/09/24 | Source: MSSQLTips.com | Category: backup / restore
Rating:  Rate this |   Briefcase | 3,875 reads

Detaching Databases - SQL School Video

One very handy technique for dealing with the need to copy or move a database involves detaching the database from your instance. MVP Brian Knight shows how easy this can be to perform on your server.  Read more...
By Brian Knight 2008/08/14 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,475 reads

Bread and Butter of SQL Server DBA - Part 1

We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.  Read more...
By MAK 2008/07/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,028 reads

Moving Databases

SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.  Read more...
By Andy Warren 2008/05/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,292 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,193 reads

Backups

By Site Owners 2008/04/21 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 5,146 reads

Backups

By 2008/04/11 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,012 reads

Differential Backups Internals

Describes how data changes for differential backups are recorded using dbcc page  Read more...
By Ken Kaufman 2007/12/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,095 reads

Push FTP with SQL Server

DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.   Read more...
By Steve Jones 2005/07/01 (first published: 2001/11/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 36,503 reads

Review of Lumigent Log Explorer v4

Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.   Read more...
By Christoffer Hedgate 2004/02/13 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 7,754 reads

Integrating SQL LiteSpeed in your existing Backup Infrastructure

This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.   Read more...
By Jeremy Kadlec 2003/05/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,347 reads
<< Newer    Items 21 to 40 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)