是否可以备份信息模式? [英] Is it possible to take the backup of information schema..?

问题描述

大家好，

是否可以备份信息模式?.

如果可能的话..?

在此先感谢..

Hai all,

Is it possible to take the backup of information schema..?

If possible how..?

Thanks in advance..

推荐答案

信息模式视图是SQL Server提供的几种用于获取元数据的方法之一.元数据是关于数据的数据.信息模式只是每个数据库中的一个视图.因此，不可能备份Information Schema.

有关SQL Information Schema的更多信息，可以参考:

1. http://weblogs.asp.net/jgalloway/archive/2006/07/07/455797.aspx [ ^ ]
2. http://www.mssqltips.com/tutorial.asp?tutorial=179 [ ^ ]
3. http://www.alberton.info/sql_server_meta_info.html [

An information schema view is one of several methods SQL Server provides for obtaining metadata & Metadata is data about data. Information schema is just a view that is there in each database. So it is not possible to take the back up of Information Schema.

For more information on SQL Information Schema, you can refer :

1. http://weblogs.asp.net/jgalloway/archive/2006/07/07/455797.aspx[^]
2. http://www.mssqltips.com/tutorial.asp?tutorial=179[^]
3. http://www.alberton.info/sql_server_meta_info.html[^]

Hope this helps.
All the best.

这篇关于是否可以备份信息模式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！