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

   Items 1 to 20 of 480    Next 20 >>
 

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree I’ve covered creating my backup directories and the actual backup of the database(s). The last...  Read more...
By 2012/02/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |  Briefcase | 598 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,808 reads

Estimated Completion Time for Backups and Restores

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...  Read more...
By 2012/01/03 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |  Briefcase | 944 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 3,006 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,660 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 | 8,432 reads

SQL 2005 Restore Script Generator

This script will generate a restore statement with supporting MOVE operations to a new directory structure.  Read more...
By Gordon-265412 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 3,454 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,808 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |  Briefcase | 4,223 reads

Check Full Recovery DBs Have Tran Log Backups

Read more...
By paul_richardson 0001/01/01 | Category: backup / restore
Rating: |  Discuss |  Briefcase | 1,635 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 8,554 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 | 1,940 reads

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.  Read more...
By Ola Hallengren 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 34,808 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 | 2,722 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 | 770 reads

TDE and Backups

Read more...
By Steve Jones 2011/08/11 | Category: tde
Rating: (not yet rated) |  Discuss |  Briefcase | 1,888 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 | 2,869 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 | 1,936 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...
By Purushotham Kumar Katakam 0001/01/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |  Briefcase | 2,178 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 0001/01/01 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |  Briefcase | 3,447 reads
   Items 1 to 20 of 480    Next 20 >>
 
Tags
maintenance and management (87)    
miscellaneous (60)    
administration (45)    
t-sql aids (38)    
sql server 7 (34)    
editorial (18)    
disaster recovery (dr) (17)    
sql server 2005 (17)    
replication (16)    
lock and connection management (14)    
sqlinsider scripts (14)    
indexing (13)    
sql server 2008 (12)    
restore (11)    
security (10)    
t-sql (10)    
blogs (9)    
configuring (8)    
editorial - ipod (8)    
editorial - wmv (8)    
strategies (8)    
editorial - mp3 (7)    
compression (6)    
data warehousing (6)    
powershell (6)    
transaction log (6)    
mail (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)    
copy_only (3)    
dts (3)    
maintenance (3)    
product reviews (3)    
alerts (2)    
availability (2)    
cloud services (2)    
installation (2)    
integration services (ssis) (2)    
recovery (2)    
red gate software (2)    
reviews (2)    
scripting (2)    
service broker (2)    
sharepoint (2)    
sql backup (2)    
sql server 2000 (2)    
sql virtual restore (2)    
stored procedures (2)    
striped backups (2)    
triggers (2)    
upgrade (2)    
user defined function (udf) (2)    
visual basic 6 (2)    
webinar (2)    
7zip (1)    
ado (1)    
advanced querying (1)    
archive (1)    
backup (1)    
backup compression (1)    
bcp (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)    
english query (1)    
enterprise (1)    
environment variables (1)    
errorlogs (1)    
export (1)    
filegroups (1)    
filestream (1)    
friday poll (1)    
gzip (1)    
job (1)    
jobs (1)    
kill (1)    
litespeed (1)    
log (1)    
log directory (1)    
log path (1)    
log shipping (1)    
maintenance plans (1)    
maintenance tasks (1)    
maintenance/ administration (1)    
management (1)    
management studio (ssms) (1)    
openxml (1)    
orphaned users (1)    
other (1)    
permissions (1)    
personally identifiable information (1)    
pii (1)    
point-in-time (1)    
policy based management (1)    
raid (1)    
rants (1)    
recent backups (1)    
recovery model (1)    
reporting services (ssrs) (1)    
restores (1)    
scripts (1)    
single user (1)    
smo (1)    
snapshot (1)    
sp_send_dbmail (1)    
sponsored article (1)    
sql azure (1)    
sql server 2008 r2 (1)    
sqlclr (1)    
sqlserver (1)    
sqlservercentral (1)    
statistics (1)    
syntax check (1)    
system administration (1)    
tde (1)    
transactional replication (1)    
transactions (1)    
truncate logs (1)    
updategrams (1)    
utility (1)    
windows home server (1)    
xml (1)    
xp_cmdshell (1)    
xsl (1)    
zip (1)    
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.