Viewing 15 posts - 4,681 through 4,695 (of 6,676 total)
If you're up for a little drive - just north on I-15 is Temecula Wine Country. Plenty of wineries to visit if you like that kind of thing.
Mind you,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 1:40 pm
sql server developer (8/12/2009)
I have a table from which I need to delete duplicate records. I dont have identity col and i cannot add identity col. For that i've used...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2009 at 9:40 am
zuma01 (8/14/2009)
Seems to be running better but the PF usage in Task Manager...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 9:47 pm
The maintenance cleanup task expects the extension without the period. If you put the period in, it will not remove any files.
Also, make sure you have selected the right...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 10:19 am
zuma01 (8/14/2009)
Sorry it is SQL 2005 Standard Edition. I havn't ticked the AWE box, is it just a case of doing that ? will that help?
I can post the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 9:34 am
nigelc (8/14/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 14, 2009 at 9:29 am
htt (8/13/2009)
As soon as you perform a new full backup, you have reinstated the log chain and all transactions are being captured
This is NOT always true. Couple of my...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 11:11 pm
nigelc (8/13/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:47 pm
htt (8/13/2009)
Okay, here is a scenario for you.
At 12:10 PM Wednesday afternoon your server crashes and corrrupts your database forcing a restore. You attempt to restore from the full backup...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:41 pm
Maria Smith (8/13/2009)
What I want to know is if the current D drive is blown away (after full backup has completed and been verified)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:30 pm
shannonjk (8/13/2009)
I do admit I need to research more on recovery models, back ups...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 10:25 pm
eric (8/13/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 5:41 pm
nigelc (8/13/2009)
If i look at the log on the file server it is showing a size of 1.5gig...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 5:37 pm
The solution is rather simple - don't use backup devices. Change the plans to use a file and let SQL Server generate the file name. When you do...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 5:28 pm
htt (8/13/2009)
Lynn Pettis (8/13/2009)
htt (8/13/2009)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 13, 2009 at 4:46 pm
Viewing 15 posts - 4,681 through 4,695 (of 6,676 total)