Viewing 15 posts - 2,761 through 2,775 (of 6,676 total)
I would bet that the file you are working with does not have a CRLF as the record terminator. If the file comes from another platform - it could...
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
January 3, 2013 at 2:30 pm
TravisDBA (1/2/2013)
I guess I don't get it, what is so hard about hitting the the Windows logo key and then L ?:-D
Nothing really - until you have a messed up...
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
January 3, 2013 at 2:03 pm
It will show as synchronized - that indicator does not tell you the mode of mirroring but the state of the mirroring process and whether or not the mirrored database...
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
December 22, 2012 at 9:16 am
What do you want to happen with the 2012 instance in cluster 2?
If I read this correctly, you have 2 clusters and you want to combine the nodes into a...
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
December 4, 2012 at 2:37 pm
You can use the 'undocumented' xp_deletefile which is called from the maintenance plan cleanup task. Since it is undocumentated - it may not work in future versions, but so...
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
December 1, 2012 at 9:34 am
thava (11/22/2012)
anthony.green (11/22/2012)
If you want TableA to TableB then...
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
November 22, 2012 at 8:49 am
Why do you feel you need to reduce the size of the database? Databases grow as you add data - and unless you have had an event that grew...
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
November 13, 2012 at 1:20 pm
If the password policies are different on each node - that could effect how soon that account would be unlocked. Or, it was just the fact that logins will...
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
October 18, 2012 at 1:17 pm
charipg (10/16/2012)
Thanks.Can you please provide the system tables\views which are related to lightspeed configuration entries.
There are no system tables - Litespeed installer will install the binaries on the server, setup...
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
October 16, 2012 at 11:48 am
robert.gerald.taylor (10/1/2012)
After last night's reboot of the server, the problem has went away and the DBCC comes back fine.Rob
Not saying this is the answer, but I have seen similar issues...
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
October 1, 2012 at 9:27 am
SQLSrvrN00b (10/1/2012)
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
October 1, 2012 at 9:22 am
All the Execute SQL Task does is execute your script - so, if that script is not completing all of the tasks then the script has to be the problem.
This...
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
October 1, 2012 at 8:51 am
The next thing this could be is a problem with your script. We need to see the script now to determine if there are issues that would cause a...
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
October 1, 2012 at 8:18 am
Jeff Moden (9/30/2012)
+1. And, you should still change the awful default growth settings to something more reasonable.
Absolutely....
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 30, 2012 at 10:10 am
Wow - so much mis-information...
Tempdb will be resized to its initial size upon restart. If it has grown to 2GB over time - then that is the size it...
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 29, 2012 at 10:23 am
Viewing 15 posts - 2,761 through 2,775 (of 6,676 total)