babyoracle
发贴: 159
积分: 21
|
于 2003-06-13 08:42
据我所知MS SQL Server的备份有四种方式:complete、differential、Transaction Log、File and filegroup。如果要实现你的目的可以使用第四种,但是你在建数据库时就因该做好准备,也就是把你要备份的table建到单独的文件。 for example: --Create database USE master GO CREATE DATABASE Archive ON PRIMARY ( NAME = Arch1, FILENAME = 'd:\program files\microsoft sql server\mssql\data\archdat1.mdf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), FILEGROUP SalesGroup2 ( NAME = Arch2, FILENAME = 'd:\program files\microsoft sql server\mssql\data\archdat2.ndf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), FILEGROUP SalesGroup3 ( NAME = Arch3, FILENAME = 'd:\program files\microsoft sql server\mssql\data\archdat3.ndf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20) LOG ON ( NAME = Archlog1, FILENAME = 'd:\program files\microsoft sql server\mssql\data\archlog1.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20), ( NAME = Archlog2, FILENAME = 'd:\program files\microsoft sql server\mssql\data\archlog2.ldf', SIZE = 100MB, MAXSIZE = 200, FILEGROWTH = 20) GO --Create table use Archive go CREATE TABLE jobs ( job_id smallint IDENTITY(1,1) PRIMARY KEY CLUSTERED, job_desc varchar(50) NOT NULL DEFAULT 'New Position - title not formalized yet', min_lvl tinyint NOT NULL CHECK (min_lvl >= 10), max_lvl tinyint NOT NULL CHECK (max_lvl <= 250) ) --attention on SalesGroup2 --这样jobs就建在了,d:\program files\microsoft sql server\mssql\data\archdat2.ndf上,你就可以通过备份这个文件而备份jobs了,Good luck!
九佰 edited on 2003-06-13 08:44
|