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
Content with tags
SQL Server 2005
,
Backup / Restore
Items 1 to 20 of 20
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
Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
Read more...
By
Simon Facer
2011/12/22
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
3,245 reads
Backup Stored Proc
Script to backup 2000/2005 databases.
Read more...
By
Scott Duncan
2011/09/09
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
8,751 reads
SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
Read more...
By
Kevin van der Merwe
2011/05/30 (first published: 2008/05/05)
|
Source:
SQLServerCentral.com
|
Category:
compression
Rating:
|
Discuss
|
Briefcase
|
22,064 reads
backup database
Read more...
By
VM-723206
2010/09/22
|
Category:
sql server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,199 reads
Copy Only Backup for SQL 2005 and SQL 2008
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
Read more...
By
Additional Articles
2009/06/30
|
Source:
MSSQLTips.com
|
Category:
backup / restore
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,915 reads
Restore a SQL Server 2008 Database into SQL Server 2005
You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.
Read more...
By
Additional Articles
2009/01/26
|
Source:
DevX
|
Category:
sql server 2008
Rating:
Rate this
|
Briefcase
|
3,417 reads
Get Data, Log, Backup, and Binn Directory (SQL Server 2005)
Use this to find Data, Log, Backup, and Binn Directory for SQL Server 2005
Read more...
By
Cowboy DBA
2008/12/15
|
Source:
SQLServerCentral.com
|
Category:
data path
Rating:
|
Discuss
|
Briefcase
|
1,555 reads
SQL – Backup Methods, Some Cool Scripts
This article will tell you about some ways of taking all databases backup using one single command.
Read more...
By
Prashant Pandey
2008/11/07
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
13,208 reads
Exporting and Versioning Lookup Data: A Real-World Use of the CLR
The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.
Read more...
By
Solomon Rutzky
2008/06/24
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
|
Discuss
|
Briefcase
|
5,073 reads
SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)
SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008
Read more...
By
Kevin van der Merwe
2011/05/30 (first published: 2008/05/05)
|
Source:
SQLServerCentral.com
|
Category:
compression
Rating:
|
Discuss
|
Briefcase
|
22,064 reads
Named Pipes
Read more...
By
Site Owners
2008/04/23
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,930 reads
Backups
Read more...
By
Site Owners
2008/04/21
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
5,126 reads
Tail Log Backups
Read more...
By
Site Owners
2008/04/17
|
Category:
backup / restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,725 reads
Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
Read more...
By
Simon Facer
2011/12/22
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
3,245 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
Backup Stored Proc
Script to backup 2000/2005 databases.
Read more...
By
Scott Duncan
2011/09/09
|
Source:
SQLServerCentral.com
|
Category:
backup / restore
Rating:
|
Discuss
|
Briefcase
|
8,751 reads
Introduction to SQL Server 2005 Database Backups
Backing up a database is one of the most important things you need to do when having a database driven application. It 's only all of your data in there, right? But often developers and management don't realize the importance of backups and overall proper backup strategy for the most important side of the business – data and it's consistency.
Read more...
By
Additional Articles
2008/01/03
|
Source:
SQLTeam.com
|
Category:
sql server 2005
Rating:
Rate this
|
Briefcase
|
3,908 reads
Mirrored backup and restore commands in SQL Server 2005
Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.
Read more...
By
Additional Articles
2007/11/01
|
Source:
SQLServerCentral.com
|
Category:
sql server 2005
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,889 reads
Featured Blog: BACKUP LOG WITH NO_LOG
From one of the SQL Server 2005 storage engine lead developers comes this look at the impact of using the NO_LOG and TRUNCATE_ONLY options.
Read more...
By
Additional Articles
2007/10/24
|
Source:
SQLskills
|
Category:
backup / restore
Rating:
Rate this
|
Briefcase
|
2,976 reads
Items 1 to 20 of 20
Tags
sql server 2008
(3)
sql server 7
(2)
administration
(1)
bcp
(1)
common language runtime (clr)
(1)
compression
(1)
copy_only
(1)
data directory
(1)
data path
(1)
disaster recovery (dr)
(1)
export
(1)
log directory
(1)
log path
(1)
performance tuning
(1)
security
(1)
sqlclr
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.