Viewing 15 posts - 5,611 through 5,625 (of 9,241 total)
use this
selectobject_name(i.object_id) as TableName
, ISNULL(i.name, 'HEAP') as IndexName
, i.index_id as IndexID
, i.type_desc as IndexType
, p.partition_number as PartitionNo
, p.rows as NumRows
, au.type_desc as InType
, au.total_pages as NumPages
, au.total_pages / 128 as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2012 at 4:43 am
mark.harby (4/27/2012)
Should really be using SMO for this sort of thing.IMHO
+1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2012 at 2:07 am
Rohit, you need to join allocation_units on the correct columns, let me find my script and post it back shortly
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2012 at 12:38 am
My preference would be to invoke the SMO objects directly within C# to backup the database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2012 at 12:29 am
Fraggle-805517 (4/25/2012)
rudy - Doctor "X" (4/25/2012)
How much RAM on the Windows side ?
How much RAM is allocated to SQL Server ?
Are you using any startup trace flags...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 9:35 am
gregtm (4/25/2012)
It depends, if the replication technology sync's accounts...etc then Database. if not Server level.
accounts are not synced thats a manual process, so what it is you are trying to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 9:32 am
dba92054 (4/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 9:30 am
paul.knibbs (4/25/2012)
because you're guaranteed to only have one connection active when you use that. (And he's using Express Edition, so no problem with the Agent... :-)).
That's just it you're not!...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 8:32 am
gregtm (4/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 8:25 am
dba92054 (4/24/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2012 at 8:13 am
jasona.work (4/24/2012)
2. Grant the account access to the share and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 3:44 pm
sqlfriends (4/24/2012)
Thank you very much, that helps a lot.
If all you're looking for is index sizes and row counts, etc try this
selectobject_name(i.object_id) as TableName
, ISNULL(i.name, 'HEAP') as IndexName
, i.index_id as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 8:52 am
Fraggle-805517 (4/24/2012)
We have Litespeed set to "Verbose, cleanup on success" so I have stuff that Litespeed is looking into.The event logs don't show any restart errors.
Fraggle.
a;; of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 8:29 am
Orion Pax (4/24/2012)
Drive RAID Cnt ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 7:43 am
Have you enabled Litespeed logging this will provide more info?
Try checking the windows application and system logs for any potential restart errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2012 at 1:00 am
Viewing 15 posts - 5,611 through 5,625 (of 9,241 total)