如何在sql server中备份

本文介绍了如何在sql server中备份的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

解决方案

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

有多种方法可以备份SQL Server。请通过以下链接来帮助您： https：/ /sqlbak/blog/scheduling-backups/ [ ^ ] 如何备份SQL-Server-database-schedule-wise [ ^ ]

如果你想进行完整的数据库备份，这可能会有所帮助。 msdn.microsoft/en-us/library/ms187510%28v=sql.120%29.aspx [ ^ ]

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: sqlbak/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. msdn.microsoft/en-us/library/ms187510%28v=sql.120%29.aspx[^]