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

Content with tag backup / restore Rss

<< Newer    Items 41 to 60 of 495    Older >>
 

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,861 reads

Initialize SQL Server replication using a database backup

You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.  Read more...
By Additional Articles 2011/09/08 | Source: MSSQLTips.com | Category: transactional replication
Rating:  Rate this |   Briefcase | 2,538 reads

SQL Server Restore Tutorial

What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.  Read more...
By Additional Articles 2011/08/19 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,135 reads

Find Latest Backup

Finds the last full backup file stored in a given folder.  Read more...
By Carolyn Richardson 2011/08/18 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,074 reads

TDE and Backups

Rating: (not yet rated) |  Discuss |   Briefcase | 2,005 reads

Backup to multiple files for faster and smaller SQL Server backup files

Write your database backup to multiple files. In addition to writing your database backup to one file you have the ability to write to multiple files at the same time and therefore split up the workload. The advantage to doing this is that the backup process can run using multiple threads and therefore finish faster as well as having much smaller files that can be moved across the network or copied to a CD or DVD.  Read more...
By Additional Articles 2011/07/29 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,481 reads

SQL Server Database Backup and Restore Failure Notifications

SQL Server ships with native alerts that can be configured to notify an operator when a backup or restore failure occurs. This chart shows the SQL Server 2000 backup and restore alerts.  Read more...
By 2011/07/22 | Category: sql server 2000
Rating: (not yet rated)  Rate this |   Briefcase | 2,514 reads

Backup or Restore progess

This procedure provides you the progess of the database backup or restore. We can execute the procedure to find the remaining time for completion of the backup or restore.  Read more...
Rating: |  Discuss |   Briefcase | 2,315 reads

Restore database with all necessary files

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...
By Josep 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,198 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

SQL DBAdmin toolbox - Part 1: Restore single database

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...
By Infostar 2011/06/10 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 1,418 reads

Mask PII data (Personally Identifiable Information)

When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.  Read more...
By Sylvia Moestl Vasilik 2011/06/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,059 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,107 reads

SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...
By Press Release 2011/05/26 (first published: 2011/05/23) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,842 reads

SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA

Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software. This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.   Read more...
By Press Release 2011/05/26 (first published: 2011/05/23) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,842 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,196 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,732 reads

Backup & Restoration Script

This script provides very useful information about database backup and restoration.  Read more...
By Ashish Gilhotra 2011/05/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,714 reads
<< Newer    Items 41 to 60 of 495    Older >>
 
Tags
maintenance and management (86)    
miscellaneous (60)    
t-sql (49)    
administration (46)    
sql server 7 (34)    
editorial (21)    
disaster recovery (dr) (17)    
replication (16)    
sql server 2005 (16)    
lock and connection management (14)    
sqlinsider scripts (14)    
blogs (12)    
indexing (12)    
restore (12)    
sql server 2008 (11)    
security (10)    
configuring (8)    
editorial - ipod (8)    
editorial - wmv (8)    
strategies (8)    
editorial - mp3 (7)    
compression (6)    
data warehousing (6)    
powershell (6)    
transaction logs (6)    
mail (5)    
maintenance (5)    
performance tuning (5)    
programming (5)    
video (5)    
analysis services (ssas) (4)    
data retention (4)    
database snapshots (4)    
downtime (4)    
legal issues (4)    
monitoring (4)    
sql-dmo (4)    
automation (3)    
azure (3)    
backup / recovery (3)    
copy_only (3)    
dts (3)    
product reviews (3)    
stored procedures (3)    
alerts (2)    
availability (2)    
backup (2)    
cloud services (2)    
database weekly (2)    
installation (2)    
integration services (ssis) (2)    
recovery model (2)    
red gate software (2)    
reviews (2)    
scripting (2)    
service broker (2)    
sharepoint (2)    
sql backup pro (2)    
sql server (2)    
sql server 2000 (2)    
sql virtual restore (2)    
sqlclr (2)    
striped backups (2)    
triggers (2)    
upgrading (2)    
user defined function (udf) (2)    
visual basic 6 (2)    
webinar (2)    
7zip (1)    
ado (1)    
advanced querying (1)    
archive (1)    
backup compression (1)    
bcp (1)    
books (1)    
c# (1)    
cleanup (1)    
common language runtime (clr) (1)    
compression ratio (1)    
data (1)    
data directory (1)    
data path (1)    
database mail (1)    
database state (1)    
days since last backup (1)    
dba (1)    
dbcc checkdb (1)    
delete (1)    
delete backup files (1)    
differential backup (1)    
distributed queries (1)    
ebook (1)    
english query (1)    
enterprise (1)    
environment variables (1)    
errorlogs (1)    
export (1)    
filegroups (1)    
filestream (1)    
friday poll (1)    
gzip (1)    
instant file initialization (1)    
job (1)    
jobs (1)    
kill (1)    
litespeed (1)    
log (1)    
log directory (1)    
log path (1)    
log shipping (1)    
maintenance plans (1)    
management (1)    
management studio (ssms) (1)    
openxml (1)    
orphaned users (1)    
other (1)    
partial backups (1)    
permissions (1)    
personally identifiable information (1)    
pii (1)    
point-in-time (1)    
policy based management (pbm) (1)    
query tuning (1)    
raid (1)    
rants (1)    
recent backups (1)    
reporting services (ssrs) (1)    
restores (1)    
scripts (1)    
single user (1)    
smo (1)    
snapshot (1)    
sp_send_dbmail (1)    
sponsored article (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sqlservercentral (1)    
syntax check (1)    
system administration (1)    
transactional replication (1)    
transactions (1)    
transparent data encryption (tde) (1)    
truncate log (1)    
updategrams (1)    
utility (1)    
visual studio (1)    
w h (1)    
windows home server (1)    
xml (1)    
xp_cmdshell (1)    
xsl (1)    
zip (1)