Viewing 15 posts - 3,571 through 3,585 (of 6,676 total)
fawwad (9/26/2010)
Adiga (9/24/2010)
Maintenance clean up task is the easiest method to clean up old backup files.
I have even tried Maintainance clean up task but no effect.
when i am going to...
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
September 26, 2010 at 10:09 am
Craig Farrell (9/23/2010)
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
September 23, 2010 at 5:35 pm
Bad driving? Try driving anywhere in southern california when it sprinkles. If you haven't had the pleasure, imagine watching multiple vehicles performing 360's on the freeway at 80...
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
September 23, 2010 at 3:55 pm
Sorry - but no, there is no option available for marking space inside a file as reusable.
Your best option is going to be using a separate file for each transaction...
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
September 22, 2010 at 5:43 pm
To copy the data, you might want to try SQL Data Compare. You can download a fully functional trial edition from Redgate.
When you perform the comparison, it will generate...
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
September 22, 2010 at 5:41 pm
Another thing to note is that you don't need or want to run DBCC CHECKDB ... WITH DATA_PURITY all the time. In fact, according to BOL - 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
September 21, 2010 at 2:49 pm
Okay, I see what you are saying. But, if that was required you could always use the execute sql task.
So, yes there are issues where certain built in tasks...
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
September 16, 2010 at 1:41 pm
sqlbuddy123 (9/15/2010)
...
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
September 15, 2010 at 7:17 pm
Steve Jones - Editor (9/15/2010)
I would be interested to hear why...
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
September 15, 2010 at 3:19 pm
Yes, you can install x86 on your x64 system - but why do you think you need to do that? There are a few known issues where you would...
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
September 14, 2010 at 2:47 pm
SKYBVI (9/14/2010)
Is there a way to know which application on prod server is trying to connect to VM every minute..??How to proceed?
Regards,
Sushant
Start up Profiler and trace the login event -...
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
September 14, 2010 at 2:24 pm
JC-3113 (9/14/2010)
well I must be having a really bad day as i cannot see it
i canot open up the task that does the backup as that gete ther min-max...
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
September 14, 2010 at 2:15 pm
There is no need to perform two integrity checks - perform your integrity check first, then backup the database.
I would have a separate plan (or sub-plan) that only performs 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
September 14, 2010 at 2:10 pm
Roust_m (9/10/2010)
Eureka! I should just drop the indexes and re-create them and then only re-index the current partition!😛
That might work - but, be aware that during that operation...
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
September 10, 2010 at 8:12 pm
Roust_m (9/10/2010)
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
September 10, 2010 at 8:00 pm
Viewing 15 posts - 3,571 through 3,585 (of 6,676 total)