如何在sql server中备份 [英] how to make back up in sql server

问题描述

我必须创建每日备份，其中我还必须备份备份，以便其他用户可以在死锁情况下访问该数据

解决方案

让我们看看是否有任何文档... 备份概述（SQL Server） ） [ ^ ]。

有多种方法可以备份SQL Server。请通过以下链接来帮助您：



https：/ /sqlbak.com/blog/scheduling-backups/ [ ^ ]



如何备份SQL-Server-database-schedule-wise [ ^ ]

< blockquote>如果你想进行完整的数据库备份，这可能会有所帮助。



https://msdn.microsoft.com/en-us/library/ms187510%28v=sql.120%29.aspx [<一个href =https://msdn.microsoft.com/en-us/library/ms187510%28v=sql.120%29.aspx\"target =_ blanktitle =New Window> ^ ]

i have to create a daily back up in which i also have to make copy of back up so that other user can access that data at the deadlock situation

解决方案

Let's see if there is any documentation..."Backup Overview (SQL Server)"[^].

There are multiple ways to take backup of SQL Server. Please go through below link that will help you:

https://sqlbak.com/blog/scheduling-backups/[^]

How-to-take-backup-of-SQL-Server-database-schedule-wise[^]

If you want to do a full database backup, this might help.

https://msdn.microsoft.com/en-us/library/ms187510%28v=sql.120%29.aspx[^]

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