Tuesday, July 26, 2011

How to fix Error Messages occur during Database Creation Process

In this article, we will discuss about how to fix error messages that occur during the database creation process.

When database administrator is trying to create a new database by using CREATE DATABASE statement in the MS SQL server database, he may get some error messages that inform, you are not able to create a database. He may receive following error messages.

Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name '' may be incorrect.

Server: Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.


What is the Cause?


Path of default data directory and default log directory are store in the folder but the path of folder store in the registry values. When the path of folder is incorrect then MS SQL server throws above error messages.

How to Fix?


You can fix or repair sql server error messages by using of SQL server Enterprise manager. SQL server Enterprise manager is able to set the default directory value and default log directory value of SQL server database. To fix the error messages follow the given below steps:

  • Go to the Start Button of your system
  • Point to Microsoft SQL Server database
  • Click on the Enterprise manager
  • In enterprise manager, right click on your instance and select properties
  • In properties, click on the database setting button.
  • Now go to the new database default location section
  • Correct folder path from default directory box and default log directory box
  • Press OK
  • Stop the instance of MS SQL database
  • Restart the instance of MS SQL server database.

No comments:

Post a Comment