Viewing 15 posts - 3,886 through 3,900 (of 6,676 total)
You are welcome - thank you for the feedback.
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
April 28, 2010 at 1:41 pm
How did you move the logins to the new server?
If you just created them manually, or ran a script that created them - then you probably have orphaned users.
Run 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
April 28, 2010 at 1:29 pm
Oh - one more thing, use the catalog views:
sys.trace_columns
sys.trace_events
sys.trace_categories
sys.trace_event_bindings
sys.trace_subclass_values
With the above, you can convert the internal column/event id's to their external values.
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
April 28, 2010 at 12:42 pm
You can replace the function fn_trace_getinfo with:
SELECT * FROM sys.traces;
To get more information about the traces running, use the following functions:
fn_trace_getfilterinfo
fn_trace_geteventinfo
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
April 28, 2010 at 12:39 pm
Matt Miller (#4) (4/28/2010)
Jeff Moden (4/23/2010)
Bhuvnesh (4/23/2010)
Also check ANSI_NULL and ANSI_PADDING settings on both databases ?Spot on.
How is len going to be affected by either of those settings? I...
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
April 28, 2010 at 10:08 am
What have you tried so far? Lookup database_principals and server_principals in books online.
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
April 28, 2010 at 10:03 am
It sounds like you have a problem with the network between the servers. When backing up across the network the backup file is being corrupted.
Unless you can guarantee your...
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
April 28, 2010 at 9:57 am
chanti2985 (4/28/2010)
tlogbackup-everyday except sundayfull backup-sunday
Okay, then you really need to review the article on managing transaction logs that I link to in my signature. Either you are not actually...
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
April 28, 2010 at 9:13 am
My recommendation is to not shrink the databases - as I said before, it is just a waste of 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
April 28, 2010 at 8:50 am
That should fix the problem - unless there are other jobs doing the same thing.
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
April 27, 2010 at 7:38 pm
bilex7226 (4/27/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
April 27, 2010 at 7:36 pm
bilex7226 (4/26/2010)
That worked by creating a named instance for SSRS. I guess that correct right?
You should not have had to do that - but it shouldn't be a problem.
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
April 27, 2010 at 7:35 pm
Lowell (4/26/2010)
1. you want to create a view for every table in the database, but exclude...
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
April 26, 2010 at 2:25 pm
There is nothing in that script that would cause the issue you are having. It has to be some other script that is breaking the log chain.
Two questions:
1) 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
April 26, 2010 at 2:16 pm
Review the article again - it shows 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
April 25, 2010 at 11:19 pm
Viewing 15 posts - 3,886 through 3,900 (of 6,676 total)