Viewing 15 posts - 5,611 through 5,625 (of 9,244 total)
Hans Lindgren (4/30/2012)
should require a RESTORE LOG and not a RESTORE DATABASE.Anyone knows why this seems to work?
That's because the command that will run is a log restore, i ran...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2012 at 11:29 am
Dev (4/29/2012)
It would be lot easier than Export / Import Data Task.
huh, how do you work that out, they both have the same end result, execute an SSIS package!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2012 at 7:09 am
wmlbill (4/26/2012)
--------------------------------------------------------------------------------
Hi all,
Some how the log file name on one of my databases changed from dbname_log.ldf to dbname_1.LDF Can anyone explain why this happened?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 27, 2012 at 4:52 am
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
Viewing 15 posts - 5,611 through 5,625 (of 9,244 total)