Viewing 15 posts - 586 through 600 (of 636 total)
Before I get home I need to be familiar with the next script which shrinks the database file sizes.
So before w move.. Here is the output from the first script.
Although...
February 4, 2011 at 12:02 pm
Sorry, I should have mentioned this earlier.
I just ran the script against another database to see how it worked.
This is not the real database that is giving me the...
February 4, 2011 at 11:00 am
mw112009 (2/4/2011)
3550.19 304.26 ...
February 4, 2011 at 10:54 am
Hope this output is very clear ( Earlier reponse the numbers got mixed... )
3550.19 304.26 3245.93...
February 4, 2011 at 10:51 am
Ok ran the first script --- here are the results
File Size Used Unused Type DBFileName
======================================
3550.19295.853254.34LogNextGen_Log
207.13176.9430.19DataNextGen_System_Data
4911.504505.19406.31DataNextGen_Core_Data_1
5235.694431.13804.56DataNextGen_Index_1
13904.519409.114495.40*** Total for...
February 4, 2011 at 10:48 am
Let me explain:
I am not in a place where I have access to this intermediate server at the moment. When I get to that location ( after 6 PM Eastern...
February 4, 2011 at 10:39 am
Ninja's_RGR'us (2/4/2011)
You need to get the data for each table and then order by rowcount and / or size to see...
February 4, 2011 at 10:16 am
Michael Valentine Jones (2/4/2011)
February 4, 2011 at 9:25 am
Ninja's_RGR'us (2/4/2011)
mw112009 (2/4/2011)
3.) Can you please explain why you need to switch recovery modes ( What is the advantage )
The transactions don't need to be log in most dev environements......
February 4, 2011 at 8:36 am
1.) Ok, I know what a checkpoint is (thanks )
2.) Also know how to shrink the entire database using the command you mentioned ( Will this take care of shrinking...
February 4, 2011 at 8:25 am
Ninja's_RGR'us (2/4/2011)
February 4, 2011 at 7:08 am
Ninja's_RGR'us (2/4/2011)
mw112009 (2/4/2011)
Hello!I am interested in shrinking the size of the backup file ( not the log file ).
Your command looks like it is going to shrink the transaction log.
The...
February 4, 2011 at 6:42 am
Hello!
I am interested in shrinking the size of the backup file ( not the log file ).
Your command looks like it is going to shrink the transaction log.
February 4, 2011 at 6:24 am
Let me ask you a question here.
Why are you dividing by 128 ?
I thougt you divide by 1024 to convert to megabytes
( or you can divide it by 1024*1024...
February 3, 2011 at 3:18 pm
These are the stats I got from the real prod database ( I did not do any shrinking yet on this one )
NGProdNextGen_System_Data308.5000007.937500
NGProdNextGen_Log ...
February 3, 2011 at 3:11 pm
Viewing 15 posts - 586 through 600 (of 636 total)