Mike
asked on
I have an unknown large SQL database I want to get rid of
I have an 84gb SQL DB that I have no idea what it is for. I installed a brand new instance of SQL Server 2008R2 on a server and the only thing connected to that SQL server is my document management software (I have a seperate SQL Server that runs everything else). For whatever reason there's a DB with a random alphanumeric name that is taking up 84gb and I'm not sure what it is for and I want to get rid of it to recover that space.
dwsql.png
dwsql.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here are the users and the results of EXEC SP_WHOThe intention was you to check for the results:
"You can also see if there's some connection right now by running the following command and check in the results by the database name:"
Anyway, by your screenshots I couldn't see any connection to the databases. This may mean that nobody is connecting to them. At least right now.
You can also check who and when they were created by running the following command:
EXEC sp_helpdb 'DatabaseNameHere'
These databases were created by your Documenting system most probably. Do you know what is the origin of this system?
Sharepoint uses such DB names.
Sharepoint uses such DB names.
ASKER
My document management vendor initially said they were not related to them and most likely related to SQL reporting. However, the DB creation date is the same day they installed the software on that server, whereas I Installed SQL about 4-5 days prior. I feel like if it was related to reporting it would've been created the day I installed the SQL instance. I just sent them another email.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was going to wait till the weekend when my backups run and then take them offline and see what happens when my users go to use that system monday morning.
ASKER
Took it offline and nothing has been affected. Moved the DB to another location and nothing negative has happened.
Perhaps the 'random alphanumeric name' is generated by a wizard to represent something, such as clients.
<Off topic, humor only> Do me a favor and see if there is a table named EE_ADMINS_COMPROMISING_PHO