Custom Log Shipping

By icata, 2005/02/15

Total article views: 480 | Views in the last 30 days: 16

Rate this |

Join the discussion |

Briefcase

There are mainly two components. One job that is managing the full database backup - restore and a second job that manage the transaction log backup - restore. At this two a new one similar with the full database backup - restore can be added for the differential backups if is the case.

I will post only the one for full backup. If you want to see the one for transaction log please let me know and I will post it. It is like the full backup one but more simpler.

Hope you will find it usefull.
I am adding also the Transaction Log shipping part of the Log Shipping.

By icata, 2005/02/15

Total article views: 480 | Views in the last 30 days: 16

Your response

Rate this |

Join the discussion |

Briefcase

Digg

Delicious

Technorati

Related tags

BCP out a table

By Steve Jones | Category: Backup / Restore

| 2,295 reads

BCP in a table

By Steve Jones | Category: Backup / Restore

| 1,660 reads

Stored Procedure to Backup all Databases

By Wesley Brown | Category: Backup / Restore

| 2,516 reads

Differential Backups of all Databases

By Wesley Brown | Category: Backup / Restore

| 956 reads

Like this? Try these...

Function to get a valid user error number

By Rodrigo Acosta | Category: Miscellaneous

| 66 reads

Import network computer EventLogs to SQL table

By mdenner

| 483 reads

Get Data/Log File Names, Sizes, Percent Utilization--ALL DBs

By John Jakob

| 163 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com