通过c＃中的帐户SQL服务器获取服务器的目录 [英] get directory of server by account SQL server in c#

问题描述

亲爱的所有

我正在用c＃语言做一个项目winform。我的应用程序有一个模块是备份数据库到.bak并保存在同一服务器的文件夹中。

但我不知道如何通过帐户SQL服务器获取服务器目录。

显示就像查找要附加到SQL服务器的文件一样。

解决方案

如果该服务器中已存在的任何数据库的任何备份，则可以获取文件路径通过以下查询：

从msdb.dbo.backupmediafamily中选择physical_device_name 

在这些路径中你可以获得任何一个并执行以下查询来创建数据库的备份：

  BACKUP   DATABASE   @ DBName  
  TO   DISK  =  @ Path  
  WITH  FORMAT; 

dear All
I am doing a project winform by c# language. my application has a module is backup database into .bak and save in folder in same server.
But I don't know how to get directory of server by account SQL server.
it is display like when find file to attach to SQL server.

解决方案

If any backup of any database already present in that server then you can get the file path by the following query:

select physical_device_name from msdb.dbo.backupmediafamily

among those paths you can get any one and execute following query to create backup of your database:

BACKUP DATABASE @DBName
TO DISK = @Path
   WITH FORMAT;

这篇关于通过c＃中的帐户SQL服务器获取服务器的目录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！