<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
T-SQL
,
Backup / Restore
Items 1 to 20 of 56
Next 20 >>
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,687 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
Read more...
By
Josep
2011/07/13
|
Source:
SQLServerCentral.com
|
Category:
restore
Rating:
|
Discuss
|
Briefcase
|
3,908 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,124 reads
Backup & Restoration Script
This script provides very useful information about database backup and restoration.
Read more...
By
Ashish Gilhotra
2011/05/04
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
5,192 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,124 reads
Backup & Restoration Script
This script provides very useful information about database backup and restoration.
Read more...
By
Ashish Gilhotra
2011/05/04
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
5,192 reads
Restores
Read more...
By
Steve Jones
2008/12/16
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,744 reads
Auto generate SQL Server restore script from backup files in a directory
One of the ongoing challenges of a DBA is to backup and restore databases. Backups are done on an automated schedule, but restores can take on many different versions, you may need to restore a production database, restore a development or test database or just create another copy of the database somewhere else. There are several ways of automating the restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.
Read more...
By
Additional Articles
2008/09/29
|
Source:
MSSQLTips.com
|
Category:
backup / restore
Rating:
Rate this
|
Briefcase
|
4,273 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,687 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
Read more...
By
Josep
2011/07/13
|
Source:
SQLServerCentral.com
|
Category:
restore
Rating:
|
Discuss
|
Briefcase
|
3,908 reads
Restore 2000 DB to 2005
Read more...
By
David A. Long
2013/05/22
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
4,401 reads
Get Record Count for each table in a database.
Read more...
By
Hari Sharma
2013/05/22
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,367 reads
Get record count for every table in a database
Read more...
By
Wayne West
2007/05/24
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,694 reads
Get record count for every table in a database
Read more...
By
Wayne West
2007/05/24
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,694 reads
Fix Users
Read more...
By
pamarant
2007/04/27
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
1,264 reads
Send SMS from a trigger
Read more...
By
Al Siks
2007/04/16
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,582 reads
Get record count for every table in a database
Read more...
By
Wayne West
2007/05/24
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
2,694 reads
Delete Old backup Files
Read more...
By
Shas3
2006/01/20
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,582 reads
usp_ToggleDatabases
Read more...
By
David Rowland
2005/08/04
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
466 reads
Push FTP with SQL Server
DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.
Read more...
By
Steve Jones
2005/07/01 (first published: 2001/11/01)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
36,459 reads
Items 1 to 20 of 56
Next 20 >>
Tags
maintenance and management
(29)
miscellaneous
(28)
sqlinsider scripts
(9)
lock and connection management
(7)
sql server 7
(6)
administration
(5)
indexing
(5)
replication
(5)
configuring
(3)
dts
(3)
data warehousing
(2)
installation
(2)
mail
(2)
restore
(2)
security
(2)
stored procedures
(2)
triggers
(2)
user defined function (udf)
(2)
advanced querying
(1)
distributed queries
(1)
english query
(1)
filegroups
(1)
monitoring
(1)
openxml
(1)
performance tuning
(1)
programming
(1)
sql-dmo
(1)
strategies
(1)
updategrams
(1)
utility
(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.
