<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Backup / Restore
Items 1 to 20 of 483
Next 20 >>
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
|
16,708 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
|
2,584 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
|
631 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,269 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,472 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,472 reads
Disaster In The Real World - #2
Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.
Read more...
By
Andy Warren
2012/12/14 (first published: 2002/07/31)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
10,459 reads
SQL Server Backup Questions We Were Too Shy to Ask
During presentations about doing database backups and restores, there seem to be two two types of questions that are commonly asked, Those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.
Read more...
By
Additional Articles
2012/12/11
|
Source:
SimpleTalk
|
Category:
backup / restore
Rating:
Rate this
|
Briefcase
|
2,938 reads
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,151 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,472 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,173 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,203 reads
Delete old backup
Delete old backup files on a prespecified folder.
Read more...
By
Matimba Maluleke
2012/07/03
|
Source:
SQLServerCentral.com
|
Category:
sql
Rating:
|
Discuss
|
Briefcase
|
1,067 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,675 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,002 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,305 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
|
2,885 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
|
97 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,829 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,727 reads
Items 1 to 20 of 483
Next 20 >>
Tags
maintenance and management
(86)
miscellaneous
(60)
t-sql
(47)
administration
(45)
sql server 7
(34)
editorial
(19)
disaster recovery (dr)
(17)
replication
(16)
sql server 2005
(16)
lock and connection management
(14)
sqlinsider scripts
(14)
indexing
(12)
restore
(12)
blogs
(11)
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)
backup / recovery
(3)
copy_only
(3)
dts
(3)
product reviews
(3)
alerts
(2)
availability
(2)
azure
(2)
cloud services
(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
(2)
sql server
(2)
sql server 2000
(2)
sql virtual restore
(2)
stored procedures
(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
(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)
database weekly
(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)
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)
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
(1)
sql server 2012
(1)
sqlclr
(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)
windows home server
(1)
xml
(1)
xp_cmdshell
(1)
xsl
(1)
zip
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
