完整的数据库备份(一个表除外) [英] Full Database Backup except one table

问题描述

我的查询是除一个表外，进行完整的数据库备份"

示例:数据库学生"
表格:-
1)dbo.StudentInfo
2)dbo.StudentAddress
3)dbo.Class
4)dbo.Admission
5).....

Sp's:-
1)GetStudentInfo()
2)GetStudentByClass()
3)GetStudentByName()
4)GetStudentByClassName()

备份除"dbo.Admission"表以外的学生数据库.

致谢.

解决方案

看看Sql Server中的文件组:http://msdn.microsoft.com/en-us/library/ms187087%28v=sql.105%29.aspx [ ^ ]

请通过 SQL Server 2008-使用SMO备份和还原数据库 [ http://www.sqlservercentral.com/Forums/Topic1144868-391-2.aspx#bm1147188 [ ^ ]

Hi,

My query is to "Take Full Database Backup except one Table"

Example : Database "Student"
Tables :-
1) dbo.StudentInfo
2) dbo.StudentAddress
3) dbo.Class
4) dbo.Admission
5) .....

Sp''s :-
1) GetStudentInfo()
2) GetStudentByClass()
3) GetStudentByName()
4) GetStudentByClassName()

Take backup of student database except "dbo.Admission" Table.

Thanks & Regards.

解决方案

Take a look at filegroups in Sql Server: http://msdn.microsoft.com/en-us/library/ms187087%28v=sql.105%29.aspx[^]

Please go through Generating SQL Backup Script for Tables & Data from any .NET Application using SMO[^].
Another useful article - SQL Server 2008 - Backup and Restore Databases using SMO[^].
These will help you a lot.
Thanks...

Hi...


Please refer the below one.


http://www.sqlservercentral.com/Forums/Topic1144868-391-2.aspx#bm1147188[^]

这篇关于完整的数据库备份(一个表除外)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！