asp.net線上恢複資料庫

標籤：

用於asp.net還原與恢複SqlServer資料庫的KillSpid預存程序

CREATE PROCEDURE KillSpid(@dbName varchar(20))ASBEGIN    DECLARE @sql nvarchar(500)    DECLARE @spid int        SET @sql=‘DECLARE getspid CURSOR FOR SELECT spid FROM sysprocesses WHERE dbid=db_id(‘‘‘[email protected]+‘‘‘)‘    EXEC (@sql)    OPEN getspid    FETCH next FROM getspid INTO @spid    WHILE @@fetch_status<>-1    BEGIN        EXEC(‘kill ‘[email protected])        FETCH next FROM getspid INTO @spid    END    CLOSE getspid    DEALLOCATE getspidENDGO

 

恢複資料庫：

  關鍵字：//Alter Database 被恢複的資料庫名 Set Offline with Rollback immediate;
            restore database 被恢複的資料庫名 from disk = ‘備份檔案路徑‘;
            //Alter Database 被恢複的資料庫名 Set OnLine With rollback Immediate;

asp.net線上恢複資料庫