<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 tags
Administration
,
Backup / Restore
Items 1 to 20 of 51
Next 20 >>
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,463 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,007 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,949 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,263 reads
Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
Read more...
By
Richard Doering
2011/06/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,125 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
2011/05/20
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
12,938 reads
Backup all databases & check backups
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
Read more...
By
Pavle-192195
2011/05/13
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
2,560 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,250 reads
Restoring after TRUNCATE TABLE
Read more...
By
Duncan Pryde
2011/03/09
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,923 reads
Default Backup Directory
Read more...
By
Duncan Pryde
2011/02/23
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,552 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
2011/01/26
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
7,252 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,921 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,657 reads
Setting SQL Server Default Locations
How to set the default locations for backups, data files, and log files in SQL Server.
Read more...
By
Wayne Sheffield
2010/11/11
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
5,353 reads
Backup all Filegroups
A short script to backup all filegroups, for those who utilise filegroups within a database.
Read more...
By
Richard Doering
2011/06/29
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
1,125 reads
Statistical Sampling for Verifying Database Backups
A DBA's huge workload can start to threaten best practices for data backup and recovery, but ingenuity, and an eye for a good tactic, can usually find a way. For Tom, the revelation about a solution came from eating crabs. Statistical sampling can be brought to bear to minimize the risk of failure of an emergency database restore.
Read more...
By
Additional Articles
2010/06/01
|
Source:
SimpleTalk
|
Category:
backup / restore
Rating:
Rate this
|
Briefcase
|
2,279 reads
Transaction Log Growth, do you need it?
One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.
Read more...
By
James Rea
2010/05/28 (first published: 2009/01/05)
|
Source:
SQLServerCentral.com
|
Category:
transaction logs
Rating:
|
Discuss
|
Briefcase
|
32,190 reads
Perform a Striped Backup
The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...
Read more...
By
Bru Medishetty
2009/12/16
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,772 reads
Custom cleanup procedure for backup files
There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.
Read more...
By
Roshan Joe Joseph
2009/11/05
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
1,396 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,657 reads
Items 1 to 20 of 51
Next 20 >>
Tags
sql server 7
(16)
configuring
(8)
miscellaneous
(7)
replication
(5)
strategies
(5)
t-sql
(5)
disaster recovery (dr)
(4)
indexing
(4)
dts
(3)
availability
(2)
installation
(2)
monitoring
(2)
performance tuning
(2)
programming
(2)
restore
(2)
security
(2)
stored procedures
(2)
triggers
(2)
user defined function (udf)
(2)
ado
(1)
advanced querying
(1)
backup / recovery
(1)
blogs
(1)
cleanup
(1)
copy_only
(1)
distributed queries
(1)
english query
(1)
errorlogs
(1)
filegroups
(1)
instant file initialization
(1)
jobs
(1)
kill
(1)
openxml
(1)
powershell
(1)
product reviews
(1)
recent backups
(1)
reviews
(1)
sql server 2005
(1)
sql-dmo
(1)
striped backups
(1)
syntax check
(1)
transaction logs
(1)
updategrams
(1)
utility
(1)
video
(1)
visual basic 6
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
