Viewing 15 posts - 16 through 30 (of 40 total)
I think you need to get the free space % on files 1-3 up to at least 10% to give yourself some breathing room. If you have the storage...
February 18, 2009 at 10:19 am
I guess I should have included that script as an attachment :D.
February 18, 2009 at 9:51 am
It appears that the aggregate amount of space used by all four data files is now greater than 1.5 TB. Which particular file(s) are growing and how full are...
February 18, 2009 at 9:45 am
Please substitute "FACT" for "Table_Name" in the example I posted. Oops.
Ken
February 16, 2009 at 10:06 pm
You could do a conditional check on the table prior to executing your aggregation query:
IF EXISTS (SELECT 1 FROM Table_Name WHERE status = 1)
...
February 16, 2009 at 9:55 pm
Is the Reporting Services service running when you look into SQL Server Configuration Manager? Also, you can look into Administrative Tools \ Services for the SQL Server Reporting Services...
February 16, 2009 at 9:49 pm
Just to clarify: Is the instance of SQL Server and database involved using a case-insensitive collation?
Ken
February 16, 2009 at 1:48 pm
I am afraid the work around method I posted will not work. I believe your 2GB table is actually 4GB in size (index space + data space). If...
February 16, 2009 at 10:44 am
You do not have any free space in the data file to facilitate shrinking it with DBCC SHRINKFILE. Would it be possible to move the large table to another...
February 16, 2009 at 10:29 am
You are correct that SQL Server 2005 Express has a size limit of 4GB on databases (data file and transaction log file space combined).
You may want to consider SQL Server...
February 16, 2009 at 10:10 am
How large is the data file versus the transaction log file? The stored procedure sp_helpfile can assist you in determining this.
I take it that you have run sp_spaceused against...
February 16, 2009 at 9:59 am
I agree with the previous post that pointed you to the following link:
http://support.microsoft.com/kb/918992
You can use sp_help_revlogin to script your logins to a file, and have this output backed...
February 16, 2009 at 9:30 am
I felt the question was misleading as well. The ActiveX Task will migrate from SQL 2K DTS to SSIS, but the SSIS version may or may not execute properly...
February 16, 2009 at 9:23 am
I have to agree with Roy's earlier post. You really need a minimum of two DBAs if you ever want to take a vacation. An alternative could be...
February 13, 2009 at 9:57 am
Hi riga1966,
A 14GB transaction log is extremely large for a 33GB datafile. Is 33GB the total of all datafile space for the database? You may need to ensure...
August 11, 2008 at 3:18 pm
Viewing 15 posts - 16 through 30 (of 40 total)