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 499    Older >>
 

Restoring the SQL Server Master Database Even Without a Backup

Many DBAs back up their user databases, but not their system databases. Whatever the reason for the lack of a backup, John Grover explains how to save yourself (mostly) should you ever find yourself with no viable master database and no good backup.  Read more...
By Additional Articles 2014/07/24 | Source: MSSQLTips.com | Category: restore database
Rating: (not yet rated)  Rate this |   Briefcase | 9,060 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/07/09 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 9,984 reads

Cloud Storage Security: Are You Doing Your Part?

If the level cloud storage encryption are so high, then why is the cloud security industry experiencing such distrust?  Read more...
By Natalie Lehrer 2014/06/18 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 62 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/07/09 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 9,984 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/07/09 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 9,984 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,286 reads

How Often Do I Backup my Log?

Do you know how often to back up your SQL Server transaction log? Steve Jones has a few thoughts today and notes that you definitely need to know how to restore the log backups.  Read more...
By Steve Jones 2014/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 217 reads

Mongo Jumbo Backups

Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.   Read more...
By Tony Davis 2014/02/03 | Source: SQLServerCentral.com | Category: database weekly
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

SQL Server 2014 Backup Basics

There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.  Read more...
By Additional Articles 2014/01/16 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 2,801 reads

SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands

SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?   Read more...
By Additional Articles 2013/12/09 | Source: MSSQLTips.com | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 2,671 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,229 reads

Risky Backups

Steve Jones talks about the potential risk issues of multiple backups in one file.  Read more...
By Steve Jones 2013/10/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 323 reads

The Need for Tape

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...
By Steve Jones 2013/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 303 reads

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.  Read more...
By Philip Horan 2013/09/20 (first published: 2010/10/05) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 15,913 reads

Restore SQL Server databases remotely using my SQL CLR

Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...  Read more...
By andrew.fenna 2013/08/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,006 reads

Database Backup Restore

By Naseer Ahmad 2013/06/26 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,427 reads

Powershell Database Backup Script

Learn how to write a script for regular database backups using Powershell and SMO.  Read more...
By Jimmy Atsaves 2013/05/17 (first published: 2011/01/05) | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 20,004 reads

Custom Maintenance Plans - the T-SQL way

The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.  Read more...
By Mark Marinovic 2013/05/16 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 3,151 reads

Restoring Azure SQL Database to a Local Server

In last week’s post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us...  Read more...
By StrateSQL 2013/04/29 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,331 reads

Automate Test Database Restoration

Automate test database restorations from your production system.  Read more...
By Mike Kober 2013/04/05 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,577 reads
   Items 1 to 20 of 499    Older >>
 
Tags
maintenance and management (86)    
miscellaneous (60)    
t-sql (49)    
administration (46)    
sql server 7 (34)    
editorial (22)    
disaster recovery (dr) (17)    
replication (16)    
sql server 2005 (16)    
lock and connection management (14)    
sqlinsider scripts (14)    
blogs (12)    
indexing (12)    
restore (12)    
security (11)    
sql server 2008 (11)    
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)    
master database (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)    
restore database (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)