.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSMS - Database is filling up (Disk Drive)

Posted By:      Posted Date: October 24, 2010    Points: 0   Category :Sql Server

Good day, i need help please.

Yesterday I shrunk the Transaction Log file which freed up a lot of space, but now i shrink the log again i only have 5GB space available on Drive.

The SSIS task i run is hectic & is filling up the space on Disk Drive

Please i'm no DBA, but can i shrink the database (database - tasks - shrink - database)

Please help

View Complete Post

More Related Resource Links

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

How to restore a database to the d drive

I have a 2008 database I need to restore, but my C drive is almost full.  How do I telll it to restore my database to the D drive?  

Create database at network drive?

Is it possible to create a SqlServer database at a network drive? Thanks, Ben

copy the image from table to disk drive

i have 2000  image he saved in the table "Employee" and i want to copy this pictures from table to diskdrive and save file name by the ID

Moving sharepoint database from one drive to other

I am having the sharepoint installed on c drive which doesn't have much space. Is it possible to move the content database to some other drive on the machine. If yes, then what is the procedure and do i have to make changes anywhere related to these changes? Also is there any possibility of something going wrong somewhere during this process? thanks in advance!

Create a Database to other drive in windows 7 and can not use it?

Hi, When I create a database in (for example) Drive E and Detach it and moving it to drive F and attached it gave me an error(Pic 4).When I copy it to Drive Windows(C),gave a message(Pic 2). in Drive C I can Attach database success fully,but in this time the database was ReadOnly And I can't change any things of database(Pic 3). when I change readonly from properties again give an error(Pic 5). This link of Pictures http://rapidshare.com/files/417610898/My_Problems.rar thanx.

Missing Database Node using SSMS 2008 Express

Hello,It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS the database node is missing.Before:After: I tried refreshing the database folder but still nothing. I even uninstall but it's still the same.Thank You for your help,-imperialx

Missing Database Node in SSMS 2008 Express

Hello, It works perfectly the first time I install SSMS 2008 Express and I can access my remote database. But, after I restart my machine and open an instance of SSMS and login back, the database node is missing. I have asked this question over at asp.net forums with images (http://forums.asp.net/t/1600718.aspx).   Thanks, -imperialx

Database diagram failur - Invalid class string SSMS 2008

Hi There -  Help needed In SSMS 2008 (not express) the Database Diagram  cast the exeption "Invalid Class String" (MS Visual Database Tools). Why is this happening. I have used the diagram designer before succesfully My OS W7 - SqlServer 2008 - every thing updated  - every service pack installed I have tryed reinstall seceral times - not positiv What is going on - It had been working (1 month ago) Please help Freddy

Filling state dropdownlist according to country dropdownlist from database

Hello,I've been looking for an answer to this problem of mine but not yet able to get any solution.Please help me out. I'm having 2 dropdownlists, one for country and another for state.I want the states to be filled according to the country selected from the country ddl. I'm having:  Two dropdownlist controls as-ddlCountry and ddlState Two database tables as-Country and State Country table has fields named- C_ID(pk) and Country State table fields are-S_ID(pk), State, C_ID During page load, I'm able to bind the ddlCountry to the "Country" table in  databaseHence I could bind ddlState too  But I'm getting confused, how to bind the ddlState control so that it will show state as per country selected. I don't want to use ajax Please help me out. Thanks and Regards, Zinnia

Error while connecting to Database Engine within SSMS 2008

Error text is as below:- any suggestions ?   ===================================   Cannot connect to TEJ-PC.   ===================================   A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)   ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476   ------------------------------ Error Number: 2 Severity: 20 State: 0     ------------------------------ Program Location:      at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)    at System.Data.SqlClient.SqlInternalC

How to add existing SourceSafe database to SSMS project


I have a several large Visual Sourcesafe (VSS) databases with scripts of all objects of several SQL server databases. They were integrated into VSS using Visual Studio. But the Solution file in VSS can not be opened from SQL Server Management Studio 2008 (SSMS). (Its a .sln file, and I need a .ssmssln file). If I try I get an error saying that the solution file was created with a newer version ...

My question is : How do I create a new SSMS project and connect it to one of the existing VSS databases to make it possible to view/check in/check out all the procedures, functions, tables etc. already stored in VSS from within SSMS.

how to do sharepoint database disk usage analysis and selective replication?



I have a SharePoint 2007 database that is 16GB in size and I want to know why, and how I can reduce the size. Ideally I would like a trimmed replica to use as a developer workstation that retains a good sample data set, and has the ability to be refreshed.

Can you please tell me if there are any third party tools or other methods to accomplish this? I have found the Microsoft tool (stsadm) to be very limited in this regard.

Many thanks.

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

just installed Express on Windows7, SSMS does not see the database engine


Installed MSSQL Express 2008 R2 64-bit on my Toshiba Satellite netbook running Windows 7 (Home).

During the installation I named the local instance 'SQLEXPRESS_XXX' the XXX is a placeholder for my initials, which I don't want to say on the forum. 

I checked the config manager and it sees the services for the named instance and corresponding SQL Server Agent service, both are stopped.  I noticed both TCP/IP and named pipes were disabled, I enabled named pipes.

But when I start SSMS there is no database engine shown, when I type the instance name it can't connect.  I tried registering it, started it from the config mgr, and it could not connect using window auth.

Not sure how to fix this issue, when I have installed earlier version couple years ago (MSDE) as soon as I brought up SSMS the first time the local instance appeared in the list.


Installation filling up System Drive

I have a question regarding Installation of SQL.

Whenever I have my installation files located on D:\(for example), and I instruct SQL during installation to install everything to D:\, there are still a ton of files that get copied to the C:\ partition (%SYSTEMDRIVE%). This is a big problem for me, as most of the customers site I install and configure SQL on, has a very limited amount of space on there System Drive.

Is there a way to make SQL dump these file (Im guessing setup support files and such) to another drive during installation, so the System Drive is not impacted whatsoever?

Also, when ever I install the Service Pack for SQL, even though SQL is installed on D:\, my System Drive (C:\) shrinks dramatically. As with the above question, is there a way to prevent this from happening?

Thanks in advance for any help.

T-SQL for database size and space available (like on Database Properties page on SQL 2008 SSMS)


How can i (using T-SQL) get the database size and free space like the database properties page of SQL 2008 SSMS shows? I want to be able to display that information in our software.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend