Geek Answers Handbook

SQL Server 2008 R2, possibly creating a new database

Having real problems creating the database in my version of SQL Server 2008 R2 Express.

I followed the links to below, but without information.

Thanks in advance for your help.

TITLE: Microsoft SQL Server Management Studio

Error creating database 'test'.
(Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates .FailedOperationExceptionText & EvtID = Create + Database & LinkId = 20476

ADDITIONAL INFORMATION:

When an exception is thrown, a Transact-SQL statement or package. (Microsoft.SqlServer.ConnectionInfo)

A search in the file directory "D: \ DATA \ test.mdf" failed to execute an operating system error 2 (failed to get the text for this error. Reason: 15100). CREATE DATABASE failed. Some file names cannot be created. Check related errors. (Microsoft SQL Server, Error: 5133)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476

+4
source share
2 answers

I would suggest that the problem is with creating the mdf file in the D: \ Data folder. Can you verify that you have the permissions required for this place and that you have enough free space? Also, make sure that the mdf file with this name is no longer in this location.

+5
source

open the database properties and on the files page (in the right pane) make sure that you do not have database files with duplicate names. if there are changes, their names

0
source

More articles:


All Articles