SQL database Backup Restore script

/*
* Function: Database backup
*dbname: Database name
*bakname: Backup name, including full path
*/
Use master
BACKUP DATABASE dbname to disk= ' C:\bakName '





/*
* Function: Database restore
* @dbname: Database name
* @bakname: Backup name, including full path
*/
Use master
declare @dbname nvarchar (500)
declare @bakname nvarchar (500)
Set @dbname = ' dbname '
Set @bakname = ' C:\bakmame '
declare @spid nvarchar (20)
Declare TB cursor FOR select Spid=cast (SPID-as varchar) from master: sysprocesses where dbid=db_id (@dbname)
Open TB
FETCH NEXT from TB to @spid
While @ @fetch_status =0
Begin
EXEC (' Kill '[email protected])
FETCH NEXT from TB to @spid
End Close TB
Deallocate TB
RESTORE DATABASE @dbname
From disk = @bakname
With replace

SQL database Backup Restore script