Viewing 15 posts - 5,521 through 5,535 (of 6,676 total)
By including the columns from the outer table in your joins, you are excluding any rows where there are no matches. This is the same as if you had...
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
March 23, 2009 at 3:24 pm
Nothing I've ever seen - and you should not have seen in the 08 instance. My guess is that one of the instances was not started.
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
March 23, 2009 at 3:13 pm
That really depends upon your business, but what would happen if your boss came to you and said that you need to restore the system back to yesterday at 8:50pm,...
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
March 23, 2009 at 3:09 pm
Are you sure you did not upgrade the third 05 instance to 08?
Have you verified that the databases in the 08 instance that you are seeing are the same files...
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
March 23, 2009 at 2:44 pm
You supplied the original query with the column defined as [date]. If you don't have that column available, what do you want the [date] column to be?
I am guessing...
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
March 23, 2009 at 2:29 pm
Also, you can add a backup log operation (full recovery) or checkpoint (simple recovery) for each iteration to reduce growing the transaction log too much.
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
March 23, 2009 at 2:25 pm
I don't think the first query is working the way you think it is. By including in the where clause any column from the tables you have left...
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
March 23, 2009 at 2:20 pm
Read the article I link to in my signature to find out how to post your question so it can be answered better/faster. What you are looking for is...
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
March 23, 2009 at 1:57 pm
Thanks for the update.
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
March 23, 2009 at 12:52 pm
In addition to what Steve has outlined, you are going to have to disable/drop foreign keys before you can recreate the tables. And, don't forget to script the indexes...
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
March 23, 2009 at 12:15 pm
mgrammer (3/23/2009)
Even though I still have the tables stored on our SQL 2000...
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
March 23, 2009 at 11:44 am
Yes - it does seem to be related to SQL Server 2000. I just tried with one of my 2000 boxes and was prompted every time I opened 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
March 23, 2009 at 11:12 am
mgrammer (3/23/2009)
I went ahead and ran that statement. I'm assuming that will prevent any future tables from being marked as system, but unfortunately the existing tables did not...
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
March 23, 2009 at 10:03 am
John (3/23/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
March 23, 2009 at 10:00 am
If disk-space isn't as big an issue, and 1 hour data-loss is acceptable, is it worth simply just running a differential backup every hour and leaving it at that?
We...
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
March 23, 2009 at 9:51 am
Viewing 15 posts - 5,521 through 5,535 (of 6,676 total)