I had SQL Server 2005 on my pc and had created a few databases through it. Due to some problem, I had to reinstall it but now when i give the command "create database mydb" it says
"Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\myDb.mdf' because it already exists. Change the file path or the file name, and retry the operation."
And when i give "use mydb" command it says
Could not locate entry in sysdatabases for database 'mydb'. No entry found with that name. Make sure that the name is entered correctly.
What should I do so that it can locate my databases?
View Complete Post
Environment: SQL Server 2008 SP1 Enterprise 64 bit
Server: Windows 2008 R2 64 bit
A database was dropped. There is no entry in SQL Server logs. I have looked at other related posts on this form regarding entries in sql log when a database is dropped.
Apart from creating user triggers to monitor the databases, I was wondering if there is any place where database being dropped can be caught.