Home Database Mysql Tutorial 通过T-SQL语句实现数据库备份与还原的代码

通过T-SQL语句实现数据库备份与还原的代码

Jun 07, 2016 pm 06:03 PM
database backup

利用T-SQL语句,实现数据库的备份与还原的功能,需要的朋友可以参考下。







( dbo.sysobjects id (N) xtype (N, N, N))
.


f_getdbpath( sysname)
()


()
()
((filename)) master..sysdatabases name

((filename)) master..sysdatabases name


((,(,),))

((,(,),))
()








( dbo.sysobjects id (N) (id, N) )
.


p_backupdb
sysname, (), (), (),
()
(,) ()
(,) dbo.f_getdbpath()
(,)
(((,,)
,,(,(),))
,,((,(),),,))





()








( dbo.sysobjects id (N) (id, N) )
.


p_RestoreDb
(), sysname, (), (), , ,
()

(,)
()
, (,)
(,(,),)
, (,)
(,(,))
,()

(,) dbo.f_getdbpath()



( )
(,)




(), (),

#tb(ln (),pn (),tp (),fgn (),sz numeric(,),Msz numeric(,))
#tb ()
#f ln,tp #tb
#f
#f ,



( )

,
#f ,

#f
#f




()
#spid
spid(spid ()) master..sysprocesses dbid()
#spid
#spid


()
#spid

#spid
#spid


()






( dbo.sysobjects id (N) (id, N) )
.


p_createjob
(), (), sysname, (), ,
(,) ()

msdb..sp_add_job

msdb..sp_add_jobstep ,
,
,
,
,
,
, ,



,



msdb..sp_add_jobschedule ,
,
, , , , ,





()

p_createjob ,,

DF
p_createjob ,,


p_createjob ,,,



()


p_createjob ,,,


p_createjob ,,,


p_createjob ,,,
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP and PDO: How to perform database backup and restore operations PHP and PDO: How to perform database backup and restore operations Jul 29, 2023 pm 06:54 PM

PHP and PDO: How to perform database backup and restore operations When developing web applications, database backup and restore are very important tasks. As a popular server-side scripting language, PHP provides a wealth of libraries and extensions, among which PDO (PHP Data Objects) is a powerful database access abstraction layer. This article will introduce how to use PHP and PDO to perform database backup and restore operations. Step 1: Connect to the database Before actual operation, we need to establish a connection to the database. Use PDO pair

Analysis of project experience on MySQL database backup and recovery performance optimization Analysis of project experience on MySQL database backup and recovery performance optimization Nov 02, 2023 am 08:53 AM

In the current Internet era, the importance of data is self-evident. As one of the core components of Internet applications, database backup and recovery work is particularly important. However, as the amount of data continues to increase and business requirements become increasingly complex, traditional database backup and recovery solutions can no longer meet the high availability and high performance requirements of modern applications. Therefore, optimizing the backup and recovery performance of MySQL database has become an urgent problem that needs to be solved. In practice, we have adopted a series of project experiences to effectively improve MySQL data

How to use ThinkPHP6 to implement database backup and recovery How to use ThinkPHP6 to implement database backup and recovery Jun 20, 2023 pm 07:25 PM

In the process of developing business systems, the database is a very important part. Therefore, backing up and restoring the database is a very necessary operation. This article will combine examples of the ThinkPHP6 framework to introduce how to use ThinkPHP6 to implement database backup and recovery. 1. Database backup 1.1 Environment preparation Before performing database backup, you need to confirm the following points: 1. You need to set the bin directory address of the mysql database and add its path to the system Path variable; 2. Mysqld needs to be installed

Database backup, optimization and recovery of Pagoda Panel Database backup, optimization and recovery of Pagoda Panel Jun 21, 2023 am 09:45 AM

In today's online world, websites have become an important carrier for every enterprise, organization or individual to display their brands, services, products, etc. In order to ensure the normal operation and security of the website, we need to continuously back up and optimize the database. and recovery. As a server management software with simple operation, rich functions and beautiful interface, Pagoda Panel is also quite excellent in database management and has important functions such as backup, optimization and recovery. This article will focus on the database backup, optimization and recovery functions of Pagoda Panel and related concerns.

PHP and Memcached database backup and recovery PHP and Memcached database backup and recovery May 15, 2023 pm 09:12 PM

With the rapid development of the Internet, large-scale MySQL database backup and recovery has become one of the essential skills for major enterprises and websites. With the widespread application of Memcached, how to back up and restore Memcached has also become an important issue. As one of the main languages ​​for web development, PHP has unique advantages and skills in handling backup and recovery of MySQL and Memcached. This article will introduce in detail the implementation method of PHP processing MySQL and Memcached backup and recovery.

How to backup database in Golang? How to backup database in Golang? Jun 01, 2024 am 11:56 AM

Backing up your database in Golang is crucial to protecting your data. You can use the database/sql package in the standard library, or a third-party package such as github.com/go-sql-driver/mysql. Specific steps include: Connect to the database. Create a file to store the backup data. Use the Dump function or Exporter to back up the database to a file.

How to use thinkorm to implement database backup and restore How to use thinkorm to implement database backup and restore Jul 28, 2023 pm 02:05 PM

Title: Using ThinkORM to realize database backup and restoration Introduction: In the development process, database backup and restoration is a very important task. This article will introduce how to use the ThinkORM framework to implement database backup and restoration, and provide corresponding code examples. 1. Background introduction During the development process, we usually use databases to store and manage data. The principle of database backup and restore is to perform regular backups of the database so that the data can be quickly restored in the event of database problems or data loss. With the help of

Database backup and recovery practice: application in PHP programming Database backup and recovery practice: application in PHP programming Jun 22, 2023 pm 07:10 PM

With the development of the Internet, database backup and recovery have become a very important part of the website operation and development process. The database is the core of the website and contains a lot of important information. If data is lost or damaged, it will have a great impact on the operation of the website and the user experience. Therefore, for website operators and developers, the importance of database backup and recovery is self-evident. This article will focus on database backup and recovery operations in PHP programming for reference by developers. 1. Number

See all articles