May 27, 2003 at 1:25 am
Hi all,
after a bad manipulation, my Sql Server 2000 has created an unamed database. And i can't delete it by any way.
Did someone have the same experience?
Is there any way to delete that weird database?
Thanks
howard
May 27, 2003 at 1:32 am
Hi Howard,
sp_dbremove <db_name> is not working?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 27, 2003 at 1:38 am
Unfortunately not....the system simply can't find a database called ""...
May 27, 2003 at 1:41 am
Is there an entry in sysdatabases in master?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 27, 2003 at 1:46 am
yes and the database points toward an old MDF file that doesnt exist anymore....
That was my bad manipulation (copy of a mdf into the data directory)...
May 27, 2003 at 1:58 am
hmm,... I haven't done this before, so please consider this only as my thoughts.
I would write down the values for the entry of that db in sysdatabases.
Then delete the entry.
Then search for orphaned entries in the other systables in master.
Good luck!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 27, 2003 at 2:06 am
Hi again,
i can't modify this specific entry....i prefer to reinstall sql server,
thanks for your help
May 27, 2003 at 2:09 am
Hi Howard,
it isn't a production server, right?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 27, 2003 at 2:25 am
No not at all!
Hopefully 🙂
howard
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply