兩句SQL主要是取得當前資料庫下用戶自定義的存儲過程名和函數名
-- 取得資料庫的函數
select SysObjects.name TableName
From SysObjects SysObjects
Where SysObjects.status >= 0
And SysObjects.xtype = ' FN ' Or SysObjects.xtype = ' TF '
order by SysObjects.Name
-- 取得資料庫的存儲過程
select SysObjects.name TableName
From SysObjects SysObjects
Where SysObjects.status >= 0
And SysObjects.xtype = ' P '
order by SysObjects.Name
********************************************
標有黑粗體的部分是要根據實際情況修改的
********************************************
-- 備份資料庫
BACKUP DATABASE ACDB
TO DISK = ' C:IBTTrustTestReportDB_IBTACDB.bak '
-- 還原資料庫
IF EXISTS ( SELECT name FROM master.dbo.sysdatabases WHERE name = N ' ACDB ' )
DROP DATABASE [ ACDB ]
GO
CREATE DATABASE [ ACDB ] ON (NAME = N ' ACDB_Data ' , FILENAME = N ' C:Program FilesMicrosoft SQL ServerMSSQLdataACDB_Data.MDF ' , SIZE = 2 , FILEGROWTH = 10 % ) LOG ON (NAME = N ' ACDB_Log ' , FILENAME = N ' C:Program FilesMicrosoft SQL ServerMSSQLdataACDB_Log.LDF ' , SIZE = 3 , FILEGROWTH = 10 % )
COLLATE Chinese_Taiwan_Stroke_CI_AS -- 排序規則
GO
RESTORE DATABASE ACDB
FROM DISK = ' C:DB綜合DemoDBACDB.bak ' -- 備份路徑
GO
-- 取得資料庫的函數
select SysObjects.name TableName
From SysObjects SysObjects
Where SysObjects.status >= 0
And SysObjects.xtype = ' FN ' Or SysObjects.xtype = ' TF '
order by SysObjects.Name
-- 取得資料庫的存儲過程
select SysObjects.name TableName
From SysObjects SysObjects
Where SysObjects.status >= 0
And SysObjects.xtype = ' P '
order by SysObjects.Name
********************************************
標有黑粗體的部分是要根據實際情況修改的
********************************************
-- 備份資料庫
BACKUP DATABASE ACDB
TO DISK = ' C:IBTTrustTestReportDB_IBTACDB.bak '
-- 還原資料庫
IF EXISTS ( SELECT name FROM master.dbo.sysdatabases WHERE name = N ' ACDB ' )
DROP DATABASE [ ACDB ]
GO
CREATE DATABASE [ ACDB ] ON (NAME = N ' ACDB_Data ' , FILENAME = N ' C:Program FilesMicrosoft SQL ServerMSSQLdataACDB_Data.MDF ' , SIZE = 2 , FILEGROWTH = 10 % ) LOG ON (NAME = N ' ACDB_Log ' , FILENAME = N ' C:Program FilesMicrosoft SQL ServerMSSQLdataACDB_Log.LDF ' , SIZE = 3 , FILEGROWTH = 10 % )
COLLATE Chinese_Taiwan_Stroke_CI_AS -- 排序規則
GO
RESTORE DATABASE ACDB
FROM DISK = ' C:DB綜合DemoDBACDB.bak ' -- 備份路徑
GO