学步园

今天给大家分享一下如何备份和回复sql server 数据，

首先确保你具有DB的最高权限

在JAVA代码中 你可以这样写public class Opp extends TestCase{<br /> public void test1()<br /> {<br /> try<br /> {<br /> Connection con = DBUtils.getConn();<br /> String sql="backup database tdzl to disk='d://tdzl.bak'";<br /> Statement st = con.createStatement();<br /> st=con.createStatement();</p> <p> st.execute(sql);<br /> }catch(Exception e)<br /> {<br /> e.printStackTrace();<br /> }<br /> }</p> <p>}

在MASTER数据库中创建两个存储过程

p1

set ANSI_NULLS ON<br /> set QUOTED_IDENTIFIER ON<br /> GO<br /> ALTER proc [dbo].[killspid] (@dbname varchar(20))<br /> as<br /> begin<br /> declare @sql nvarchar(500)<br /> declare @spid int<br /> set @sql='declare getspid cursor for select spid from sysprocesses where dbid=db_id('''+@dbname+''')'<br /> exec (@sql)<br /> open getspid<br /> fetch next from getspid into @spid<br /> while @@fetch_status <> -1<br /> begin<br /> exec('kill '+@spid)<br /> fetch next from getspid into @spid<br /> end<br /> close getspid<br /> deallocate getspid<br /> end<br />

p2

set ANSI_NULLS ON<br /> set QUOTED_IDENTIFIER ON<br /> GO<br /> ALTER PROCEDURE [dbo].[restore_database]<br /> -- Add the parameters for the stored procedure here<br /> @db_name varchar(30),<br /> @db_path varchar(80)<br /> AS<br /> BEGIN<br /> execute killspid @db_name<br /> restore database @db_name from disk=@db_path with replace<br /> END<br />

回复时调用上述存储过程就得以实现

下一篇将解释如何通过JAVA调用该存储过程