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 21 to 40 of 495    Older >>
 

Quick Tip – Speed a Slow Restore from the Transaction Log

Here’s a quick tip for you: During some restore operations on Microsoft SQL Server, the transaction log redo step might be...  Read more...
By 2012/11/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,322 reads

Free eBook: SQL Server Backup and Restore

You can download a free eBook from SQLServerCentral and Red Gate software on the most important task a SQL Server DBA or developer needs to understand.  Read more...
By Press Release 2013/01/25 (first published: 2012/10/23) | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 11,765 reads

BackUp_DBs.sql

Make backup several databases with a cursor  Read more...
By @fracionero 2012/08/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,249 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,259 reads

Delete old backup

Delete old backup files on a prespecified folder.   Read more...
By Matimba Maluleke 2012/07/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,207 reads

Simplified Restores with SQL Server 2012 Recovery Advisor

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,740 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

Partial Backup and Restore

Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.  Read more...
By Additional Articles 2012/05/15 | Source: SimpleTalk | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,404 reads

Restore Server/Database users/roles

Restore server/database users and roles from another server when we are restoring databases to another server.  Read more...
By Lester Policarpio 2012/04/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,011 reads

Replace existing Database? JFDI!

Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…  Read more...
By Tony Davis 2012/04/02 | Source: SQLServerCentral.com | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

How to create a database backup using visual studio

This article describes how to backup a database using a C# Windows Form.   Read more...
By Daniel Calbimonte 2012/03/30 | Source: SQLServerCentral.com | Category: c#
Rating: |  Discuss |   Briefcase | 7,989 reads

Shrink all databases

Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).  Read more...
By Rafal Skotak 2012/03/07 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,803 reads

Database Restore

By Stuart Davies 2012/02/21 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,330 reads

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 | 1,247 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 | 4,237 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 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,320 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,514 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 2011/12/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,735 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,812 reads
<< Newer    Items 21 to 40 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)