Code for database backup and restoration using T-SQL statements

The use of T-SQL statements to achieve database backup and restoration functions, need friends can refer to the next.

The use of T-SQL statements to achieve database backup and restoration functions, need friends can refer to the next.

(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 () 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 ,,,