Click here to Skip to main content
14,365,441 members
Rate this:
Please Sign up or sign in to vote.
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)
Posted
Updated 17-Nov-11 2:46am
v2
Comments
Mehdi Gholam 15-Nov-11 4:52am
   
What is the command you are running?
Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
   
Comments
Alan Tuscano 15-Nov-11 20:00pm
   
Hi ShabanaParveen,

Thanks for the reply, and pardon me for using the word "back Up"...

I mean, I literally cannot create a New Database in the SQL SERVER 2005,

BTW, I access SQL SERVER 2005 using remote connection.

And I'm using SQL Server 2008R2, 2 pc here in the ofc is using SQL Server 2008R2 and both cannot create New Database
Shabana Parveen 16-Nov-11 0:40am
   
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.
Rate this:
Please Sign up or sign in to vote.

Solution 2

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.
EDIT: removed pre tags
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100