ScholarLens Back to search
2008•Experiment Science and TechnologyRequires access

Automatic Remote Backup of SQL Server Database

YU Ze-de

Open publisher page 0 citations

Abstract

Database backup is an important guarantee of database security. Taking SQL Server database for the background of Tiancai'financial management system as an example,this paper proposes an automatic remote database backup strategy for the current accounts and charges database, twice daily. To backup database to the Server using the SQL Server database maintenance plan features,and copy the backup files to the client using file by synchronization software Second Copy,hence securing synchronous backup data of both the server and the Client.

About this research paper

What this paper is about

Database backup is an important guarantee of database security. Taking SQL Server database for the background of Tiancai'financial management system as an example,this paper proposes an automatic remote database backup strategy for the current accounts and charges database, twice daily. To backup database to the Server using the SQL Server database maintenance plan features,and copy the backup files to the client using file by synchronization software Second Copy,hence securing synchronous backup data of both the server and the Client.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Database backup is an important guarantee of database security. Taking SQL Server database for the background of Tiancai'financial management system as an example,this paper proposes an automatic remote database backup strategy for the current accounts and charges database, twice daily. To backup database to the Server using the SQL Server database maintenance plan features,and copy the backup files to the client using file by synchronization software Second Copy,hence securing synchronous backup data of both the server and the Client.

Key concepts: Log shipping, Backup, Computer science, Database, Backup software, Autocommit, Data Transformation Services, Database server

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Automatic Remote Backup of SQL Server Database — Research Paper | ScholarLens