不创建数据库 [英] CAnnot Create DataBase

问题描述

安装在我的桌面上的是MSSQL Server 2008 R2，而我正在访问用于插入，删除和更新数据的服务器是MSSQL2005.

现在，我想在该SQL Server中创建一个备份数据库，但由于出现错误而无法:

Hi,


Installed on my desktop is MSSQL Server 2008 R2 and the Server I am accessing to insert, delete and update data is in MSSQL 2005.

Now, I wanted to create a back up database in that SQL Server, but cannot because an error appears:

Created faild for 'mbk_data'.(Microsoft.SQLServer.Smo)
ADDITIONAL INFORMATION:
   -- AnException occured while executing a Transact-SQL Statement or Batch.
    (Microsoft.SqlServer.ConnectionInfo)

   --Directory Lookupfor the file "C:\Program Files (x86)\Microsoft SQL Server\
     MSSQL.1\MSSQL\DAT\mbk_data_log.ldf" failedwith the operating system error 2
     (The system cannot find the the file specified.).

     CREATE DATABASE Failed. Some file names listed could not be created. Check
     related errors. (Microsoft SQL Server, Error: 5133)

推荐答案

如果您需要创建备份副本，可以使用sql向导，右键单击数据库，然后单击备份选项.万一您想将一个数据库复制到另一个数据库.您需要确保排序规则等类似...希望这种方法有效.

if you need to creat backup copy it can be using the sql wizard, right click on database and click on backup option. In case to you want to copy one database to another. You need to ensure that collation etc. should be similar... hope this approach works.

这可能是因为您提到要远程连接到SQL 2005时的访问权限级别.另外，SQL Server 2008 R2的配置似乎不正确.确保SQL Server服务具有本地管理员权限，然后重新启动实例.检查此链接:

http://stackoverflow.com/questions/764494/no-admin-rights- in-sql-management-studio [ ^ ]
希望设置权限许可可以解决您的问题.
删除了预标签

It may be because of the access permission level as you mentioned you are connecting remotely to SQL 2005. Also, configuration of SQL Server 2008 R2 seems to be not proper. Ensure that the SQL Server Service has local admin rights and then restart the instance. Check this links:

http://stackoverflow.com/questions/764494/no-admin-rights-in-sql-management-studio[^]
Hope, setting up rights permission resolves your issue.
removed pre tags

这篇关于不创建数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！