How to take a backup of existing Database in Sql server and Save it as script in local or TFS? I have 3 DB's under Production server to take backup
如何在Sql server中备份现有数据库并将其另存为本地或TFS中的脚本？我在生产服务器下有3个DB来进行备份
1 个解决方案
#1
0
The following Query generates BackUp .bak file of database.
以下Query生成数据库的BackUp .bak文件。
BACKUP DATABASE 'DatabaseName'
TO DISK = 'D:\FileName.bak'
#1
0
The following Query generates BackUp .bak file of database.
以下Query生成数据库的BackUp .bak文件。
BACKUP DATABASE 'DatabaseName'
TO DISK = 'D:\FileName.bak'