如何使用Sql语句备份数据库为.Bak文件在硬盘上？ [英] How Do I Backup Database Using Sql Statement As .Bak File On Hard Disk ?

问题描述

我想要备份数据库为.bak文件，我想要硬盘上的文件我使用此代码n输出是succsefull但我没有在路径上找到任何文件：

使用try2

i want to do backup for database as .bak file where i want the file on hard disk i used this code n the output is succsefull but i didnt find any file on the path:
use try2

DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name

-- specify database backup directory
SET @path = 'd:\Backup\' 
set @name='try2'
 
-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) + '_' + REPLACE(CONVERT(VARCHAR(20),GETDATE(),108),':','')


SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
       BACKUP DATABASE @name TO DISK = @fileName  --WITH  RETAINDAYS = 30, NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD,  STATS = 10

-





结果是

--


the result is

Processed 304 pages for database 'try2', file 'Council_Ministers_Meetings' on file 1.
Processed 1 pages for database 'try2', file 'Council_Ministers_Meetings_log' on file 1.
BACKUP DATABASE successfully processed 305 pages in 0.344 seconds (6.926 MB/sec). 

注意：Council_Ministers_Meetings是我没有使用的数据库名称我想为try2数据库做备份

note : Council_Ministers_Meetings is database name i didnt use where i want to do backup for try2 database

推荐答案

检查你的权限，并且SQL服务器的实例是在具有D：驱动器的机器上。



当我在这里运行该代码时，在我的开发SLQ 2008R2上文件创建正常 - 所以你需要查看磁盘相关的原因，为什么它不存在。如果您的服务器位于带有D：驱动器的计算机上，请查看此处：在C＃中备份SQL数据库 [ ^ ]在那么，它现在可以工作吗？并检查teh文件夹/用户组合的访问权限。

Check your permissions, and that the instance of SQL server is on a machine that has a D: drive.

When I run that code here, on my development SLQ 2008R2 the file is created ok - so you need to look at disk related reasons why it isn't there. If you server is on a machine with a D: drive, then look here: Backing up an SQL Database in C#[^] under "So, It'll Work Now?" and check the access permissions for teh folder / user combination.

在我检查了我的许可之后它正常工作，因为OriginalGriff说

很多伟大的比x

it works after i checked my permission as OriginalGriff said
many great thanx

这篇关于如何使用Sql语句备份数据库为.Bak文件在硬盘上？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！