Topic: 请教高手:SQL2000 SERVER 中如何备份和复原单个TABLE? |
Print this page |
1.请教高手:SQL2000 SERVER 中如何备份和复原单个TABLE? | Copy to clipboard |
Posted by: javait Posted on: 2003-06-12 10:25 知道应该用FILE 和 FILEGROUP。问题是如何恢复到指定的备份顺序,例如第一次备分或第三次备份的状态。LOG 怎么办? 谢谢 -JAVAIT |
2.Re:请教高手:SQL2000 SERVER 中如何备份和复原单个TABLE? [Re: javait] | Copy to clipboard |
Posted by: javait Posted on: 2003-06-13 01:36 已解决。关键是备份时要备份整个数据库。 谢谢! -JAVAIT |
3.Re:请教高手:SQL2000 SERVER 中如何备份和复原单个TABLE? [Re: javait] | Copy to clipboard |
Posted by: babyoracle Posted on: 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! |
4.Re:请教高手:SQL2000 SERVER 中如何备份和复原单个TABLE? [Re: javait] | Copy to clipboard |
Posted by: javait Posted on: 2003-06-13 23:38 虽然整个备份恢复过程比较繁琐,但还是要感谢 babyoracle 的奉献精神! 偶们论坛就是需要这样的好弟兄。:) 谢谢 -JAVAIT |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |