Link to home
Start Free TrialLog in
Avatar of Mike
MikeFlag for United States of America

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
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<Potentially stupid question>  Do you have the ability go to into the tables and make a determination what this is?  As a wild guess since the db is large perhaps that is where documents are stored in blob columns in various tables.

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_PHOTOS, and if yes publish this database somewhere public with no security so we can connect.  Thanks in advance.
Avatar of Mike

ASKER

Here are the users and the results of EXEC SP_WHO
dwsql2.png
dwsql3.png
Here are the users and the results of EXEC SP_WHO
The 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'

Open in new window

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.
Avatar of Mike

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike

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.
Avatar of Mike

ASKER

Took it offline and nothing has been affected.  Moved the DB to another location and nothing negative has happened.