Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2009-02-27 : 05:49:08
|
| I'm a real novice when it comes to DB Administration, therefore, I seriously need assistance.Last night, someone was loading a ton of data into a DB. This morning, I can see the DB in the object tree, but there is no plus sign next to it, and I cannot connect to it. If I right click > tasks > detach or take offline, it says the DB doesn't exist. If I try and attach the files to another database, it says cannot do so as the database has the same name as an existing DB.There is enough room on the drive on which the files are placed. There are 8 data files and 1 log file. The data files were deployed as 80GB each, but also set to grow to unlimited size, 5GB at a time.Whats wrong and what can I do to rectify the situation?Oh, its a SQL Server 2005 DB.ThanksHearty head pats |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-02-27 : 06:04:26
|
| What error mesage you are getting when trying to connect with database? Make sure your login have required permission to work with database. |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2009-02-27 : 06:15:46
|
Hi thereThanks for your reply. I've managed to resolve the issue. I looked in teh event log, and it appears that at some point, an issue occurred with the Log file (as I had errors saying that it could not find the file???).Anyway, I reattached the DB, and rebuilt the log, and it seems to be working ok. Do you know if this is something that can happen, or is it more likely that someone detatched the DB and deleted the file?? A mystery me thinks..................  Hearty head pats |
|
|
|
|
|
|
|
|
Cannot connect to DB