Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Backup SQL Server Database with Move/Copy File

By Marvin D,

The following script performs log, differential or full backups of a single, or all databases on your SQL Server.  It then copies or moves the file(s) over to a network share drive.  It also removes old backups from both locations if needed.  Don't forget to set the local drive path and network share for each backup in the backupretention table.  Also remember, to set the relocation action of copy or move.  I included the create table script as well

Total article views: 19107 | Views in the last 30 days: 97
 
Related Articles
FORUM

backup

backup

FORUM

backup

backup

FORUM

backup

backup

FORUM

Backup

Backup

FORUM

backup

backup

Tags
 
Contribute