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 61 to 80 of 495    Older >>
 

Backup and Restore of an Analysis Services Database

One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user and system databases. In this article we will take a look at the steps which a database administrator needs to follow to backup and restore an analysis services database.   Read more...
Rating:  Rate this |   Briefcase | 2,801 reads

Killing User Connection(session) connected to the Database.

The script will be helpful to kill all the user sessions before performing the refresh of the database.  Read more...
By Sourav Mukherjee 2011/04/08 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 2,340 reads

Change SQL Startup Parameters with PowerShell

Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...  Read more...
By eric.humphrey 2011/04/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,284 reads

Restoring after TRUNCATE TABLE

By Duncan Pryde 2011/03/09 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,962 reads

Default Backup Directory

By Duncan Pryde 2011/02/23 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,576 reads

Streamlining granular recovery for SharePoint, with Red Gate and Metalogix

We have recently found an elegant way to reduce the time, and disk space required for SharePoint administrators who need to perform granular recovery operations out of their SQL Server backup files. I used to get customer calls that would go something like this:  Read more...
By Additional Articles 2011/02/23 | Source: Other | Category: backup / restore
Rating:  Rate this |   Briefcase | 1,728 reads

Point-in-time restore

By Duncan Pryde 2011/02/16 | Category: backup / restore
Rating: (not yet rated) |  Discuss |   Briefcase | 2,618 reads

Dynamically Script Database Backups

Dynanically Generate Backups with Date and time  Read more...
By shanu hoosen 2011/02/11 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,880 reads

SQL Azure - Creating backups and copies of your databases

As a DBA you always followed a practice to back up your database (or take a snapshot of your database) before making any changes so that you can revert to your old database state if something goes wrong. Also to setup a development or test environment you use a backup of your database and restore it in the respective environment. If you are moving to SQL Azure, what would you do in these cases as backup / restore and database snapshots are not supported as of now?  Read more...
By Additional Articles 2011/02/10 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,067 reads

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running....  Read more...
By Steve Jones 2011/02/07 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,697 reads

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore  Read more...
By Press Release 2011/01/27 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,877 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,171 reads

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore  Read more...
By Press Release 2011/01/27 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,877 reads

SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups

The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore  Read more...
By Press Release 2011/01/27 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,877 reads

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.   Read more...
By Bharat Panthee 2011/01/06 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,964 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 | 19,835 reads

Script: Map Orphan Login and Users

Map the Orphan Login and Users.  Read more...
By Sourav Mukherjee 2011/01/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,580 reads

T-Log Backup/Restore with Date & Time

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.  Read more...
By S. Kusen 2010/12/29 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,298 reads

The Institute for Backup Trauma

Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.  Read more...
By Steve Jones 2010/12/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 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,728 reads
<< Newer    Items 61 to 80 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)