1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
USE [DATA_Q]
GO
/****** Object: StoredProcedure [dbo].[BackUpper] Script Date: 03/20/2014 22:10:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[BackUpper]
-- Add the parameters for the stored procedure here
AS
BEGIN
BACKUP database DATA_Q TO DISK = 'C:\temp\BackUp.BAK'
RESTORE FILELISTONLY FROM DISK = 'C:\temp\BackUp.BAK'
RESTORE DATABASE Clone_Data_Q FROM DISK = 'C:\temp\BackUp.BAK'
WITH MOVE 'DATA_Q' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.QUALTECHRP\MSSQL\DATA\CloneDATA_Q.mdf',
MOVE 'DATA_Q_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.QUALTECHRP\MSSQL\DATA\CloneDATA_Q_log.ldf'
END |
Partager