Viewing 15 posts - 3,226 through 3,240 (of 6,676 total)
Sergiy (5/12/2011)
Then you may send that file as a message body.
Not sure if xp_smtp_sendmail can do 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
May 12, 2011 at 8:08 pm
The real issue here is that moving the criteria for TableA to the ON clause for the join changes what you are asking SQL Server.
In the first query, you are...
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
May 11, 2011 at 9:47 pm
Tara-1044200 (5/10/2011)
Lets say the account(windows) i am using which is in problem is "OBBEAVER\SQLBAY2" and sql agent service run with 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
May 11, 2011 at 9:36 pm
Do you have auto create statistics enabled? Is Auto Update Statistics enabled? And finally, is Auto Update Statistics asynchronously enabled?
I'm thinking that maybe the system is running into...
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
May 11, 2011 at 3:42 pm
It really does not sound like a problem with the database. I would be leaning toward an issue with the way the VM's have been created. You 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
May 11, 2011 at 3:37 pm
Yes - sorry, missed that part. Looking further at the message, do you have the maintenance plan setup to create a report?
This is configured using the little button next...
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
May 11, 2011 at 3:16 pm
Syed Jahanzaib Bin hassan (5/10/2011)
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
May 11, 2011 at 3:02 pm
Yes - it is possible. How you go about setting it up depends on how the domains are configured. If the domains are fully trusted - there shouldn't...
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
May 11, 2011 at 2:54 pm
That option is one of the settings that is used to generate an execution plan. So, if you have it on for one connection and off for a different...
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
May 11, 2011 at 2:44 pm
I will say it again - look at the maintenance plan history and not the job history for better information about the error.
Right-click on the maintenance plan and View History.
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
May 11, 2011 at 2:26 pm
Well, first I do not know of any way to prevent ODBC connections to a database system and still allow an application to connect.
With that said, just because a user...
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
May 10, 2011 at 2:29 pm
That looks like the job history - check the maintenance plan history instead. It should show you why that specific task failed.
Now, not sure why you would perform rolling...
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
May 10, 2011 at 2:20 pm
This is the code I use to track backups and restores:
Select r.command
, s.text
, r.start_time
...
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
May 10, 2011 at 2:04 pm
Grant Fritchey (5/9/2011)
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
May 9, 2011 at 7:50 pm
My take on this is to have enough space in the data file for at least 6 months growth, plus enough to rebuild the largest index in the 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
May 9, 2011 at 2:21 pm
Viewing 15 posts - 3,226 through 3,240 (of 6,676 total)