在SQL Server中备份和还原 [英] Backup and Restore in SQL server

问题描述

大家好，

我有些怀疑.
我希望了解有关在SQL Server中备份和还原的信息.还有一些问题吗?

1)什么是实际的备份和还原..?
2)Backup ..的优点是什么?
3)备份中发生了什么..?
4)正在恢复的东西是什么?.

在Google中搜索时，我没有得到这些问题的答案..

希望了解更多..

请帮助我..

Hai all,

I have some doubt.
I wish known about Back up and restore in SQL-Server. and i have some questions?

1)What is actually backup and restore..?
2)What is advantage of Backup..?
3)what is happening in backup..?
4)What are things which is restoring..?

while searching in google i am not getting the answer for these questions..

wish to know more about it..?

please help me..

推荐答案

有关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

希望这会有所帮助.
一切顺利.

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.

备份意味着将数据复制到辅助位置，这样，如果遇到问题，可以使用它来还原备份时的数据. .一般的经验法则是:定期进行备份.最重要的备份是您没有备份的备份.您可能永远不需要备份，但是绝对可以确定，如果您没有备份，那么您将需要一个备份！

还原可以是可变的:还原部分或全部数据.它可以还原到您原来的位置，也可以只还原您所需的信息.

这就像编写一个大的Word文档:如果断电，您可以定期保存它.因为这样会节省您不保存的日子！

Back up means to copy the data to a secondary location, so that if you have a problem you can use it to RESTORE the data as it was when the backup was taken. A general rule of thumb is: Take backups, regularly. The most important backup is the one you didn''t take. You may never need a backup, but it is absolutely certain that if you do not have a backup, you are going to need one!

Restore can be variable: restore some or all of the data. It can restore to exactly where you were, or it can restore only that information that you know you need.

It''s like writing a large Word document: You save it regularly in case the power fails. Because it will, the day you don''t save!

阅读本文.

http://technet.microsoft.com/en-us/library/cc966495.aspx [ ^ ]

http://sqlserverdatarecovery.com/sql_backup_restore_feature.html [

Read this article.

http://technet.microsoft.com/en-us/library/cc966495.aspx[^]

http://sqlserverdatarecovery.com/sql_backup_restore_feature.html[^]

这篇关于在SQL Server中备份和还原的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！