如何连接登录并附加.bak文件 [英] How to Connect a login and attach a .bak file

问题描述

大家好



i在我的sql server中使用vb.net代码创建了一个登录。

现在请告诉我如何连接该特定用户并使用vb.net将.bak文件附加到登录。



谢谢

解决方案

< blockquote>以下是程序

  USE  AdventureWorks2008R2; 
  GO  
  BACKUP   DATABASE  AdventureWorks2008R2 
  TO   DISK  = '   Z：\ SQLServerBackups\AdventureWorks2008R2.Bak' 
  WITH  FORMAT， 
 MEDIANAME = '  Z_SQLServerBackups'，
 NAME = '  AdventureWorks2008R2的完全备份'; 
  GO  

欲了解更多信息，请尝试在以下链接中找到：



http： //forums.asp.net/t/1840530.aspx [ ^ ]



http://sqlanddotnetdevelopment.blogspot.in/2011/04/sql-server-database-backup-and-restore.html [ ^ ]

Hi all

i have created a login using vb.net code in my sql server.
Now please tell me how to connect that particular user and attach a .bak file to the login using vb.net.

Thank you

解决方案

Below is the procedure

USE AdventureWorks2008R2;
GO
BACKUP DATABASE AdventureWorks2008R2
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2008R2.Bak'
   WITH FORMAT,
      MEDIANAME = 'Z_SQLServerBackups',
      NAME = 'Full Backup of AdventureWorks2008R2';
GO

for more please try to find in below links:

http://forums.asp.net/t/1840530.aspx[^]

http://sqlanddotnetdevelopment.blogspot.in/2011/04/sql-server-database-backup-and-restore.html[^]

这篇关于如何连接登录并附加.bak文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！