Viewing 15 posts - 8,536 through 8,550 (of 9,244 total)
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances when it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 11:50 am
BOL sql2005 Dec2008 is the version
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run the checkpoint...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 11:33 am
Perry Whittle (1/6/2009)
can you post details of the job steps?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:52 am
danchard (6/30/2008)
I wanted to enter server name/instance name
the correct syntax to use is
servername\instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:52 am
check your index widths too, depending on the columns included indexes can be quite large
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:49 am
also instead of re creating and syncing the logins use the following link
http://support.microsoft.com/kb/246133
to move logins between servers, preserving the database to user relationship
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 4:48 pm
Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛
ha ha, i was wondering if this post would catch your eye Jeff.
foxjazz (1/6/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 4:28 pm
rons (1/6/2009)
but would like to see the differences between the 2 tables in one result window.
then use the correlated query Ninja supplied above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 2:17 pm
foxjazz (1/6/2009)
And you can still use c# it's easier to do this in a valid programming language than t-sql because it's easier to debug.
OK, now is time to leave the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 2:02 pm
foxjazz (1/6/2009)
it's probably easier to use a cursor to iterate through your first table.
well deserving of a pork chop this one 😀
a simple select with a correlated sub query will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:49 pm
Ells (1/5/2009)
1.The data warehouse has simple recovery mode so I dont believe this will have an issue as the database is backed up weekly before a load is performed.
under simple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:15 pm
can you post details of the job steps?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:02 pm
Mani (1/6/2009)
I used windows authentication.
doe this machine belong to a windows domain, supply more info please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:47 pm
GilaMonster (1/6/2009)
Got a backup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:41 pm
personally i'd burn them to separate disks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:37 pm
Viewing 15 posts - 8,536 through 8,550 (of 9,244 total)