Viewing 15 posts - 391 through 405 (of 468 total)
Hmm- this is indeed strange. According to these results, tables only take up <400MB. What is taking so much space in your database? Do you have many-...
April 28, 2010 at 8:00 am
So, your data file is about 11GB- 8GB is actual data and 3GB is free space. That's about appropriate- you want that free space in there for performance reasons.
Can...
April 28, 2010 at 7:22 am
Need more information. Perhaps you can implement the trace flags here: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Backup&c=knowledgebase\SQL_Backup\KB200806000267.htm
and post resulting logs
April 28, 2010 at 7:06 am
Looking at your result indicates that this particular table only accounts for 352 MB of space in your database (reserved space = total space the table takes in your db).
Can...
April 28, 2010 at 6:49 am
for the sake of anyone looking for the same, I found my own answer here: http://www.databasejournal.com/features/mssql/article.php/3347241/Checking-SQL-Servers-Heart-Beat.htm
Need to remove the extra "next" in the script for it to compile...
April 27, 2010 at 11:40 am
I have seen almost this exact behavior. In my case, the job "thought" it completed, but the DTS process never ended.
This was quite a while ago for...
April 27, 2010 at 11:34 am
When you get down to 10MB of available memory, what is using it? If SQL Server is only using 12GB, TSM a few MB, where are the other 3.x...
April 27, 2010 at 6:45 am
Please do post whether the hotfix resolves the problem or not... I've not seen this particular problem before so it's interesting.
April 23, 2010 at 11:07 am
out of curiousity, why are you considering using the -g parameter? Have you encountered errors calling extended stored procedures?
April 23, 2010 at 6:56 am
Just the active node is fine. Notice that in configuration manager, the Advanced values include "is clustered". It's smart enough to make the change on both nodes.
April 23, 2010 at 6:53 am
maybe this?
During a transfer of logins between instances of SQL Server, if the sort order of the source server is case-insensitive and the sort order of the destination server is...
April 23, 2010 at 6:45 am
Looks like this is your problem: http://support.microsoft.com/kb/941105
April 23, 2010 at 6:32 am
Can you please post for us the contents of the database mail logs, and any relevant entries in the error log, and window system and application logs?
April 22, 2010 at 12:42 pm
hmm- my thought is that work you are trying to accomplish is going to take a long time regardless of what you do, but you mention log file size issues....
April 22, 2010 at 12:39 pm
some will be data, some will be free space, and some will be indexes. Following script will find 25 biggest tables... you can of course change the "select top...
April 22, 2010 at 12:17 pm
Viewing 15 posts - 391 through 405 (of 468 total)