Viewing 15 posts - 4,786 through 4,800 (of 6,676 total)
I wonder what it says about me that I actually enjoy reading all of these books that are supposedly targeted at teens? :hehe:
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
July 24, 2009 at 10:38 am
No - it is not possible. Why would you want to anyways?
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
July 24, 2009 at 9:08 am
jay (7/23/2009)
I apply the full backup with "norecovery" and apply Differential backup with "recovery". There is no requirement to apply transaction log backups.
Executed as user: TDS\clusadminspain. Cannot...
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
July 23, 2009 at 3:18 pm
Carl Federl (7/23/2009)
SELECTROW_NUMBER ( ) OVER (ORDER BY name ) AS NameId
,name
INTO#temp
FROMsys.objects
WHEREname NOT LIKE '#%'
SELECT*
FROM#TEMP
ORDER...
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
July 23, 2009 at 12:49 pm
Do you have any tables that do not have a clustered index? On tables where there is not a clustered index, the heap can use a lot more space....
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
July 23, 2009 at 12:41 pm
Once you restore your database with recovery, you cannot restore any additional backups. You have to restore the full database with norecovery, then you can apply the appropriate differential.
What...
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
July 23, 2009 at 12:26 pm
I honestly don't think your problem is necessarily related to security - at least, not directly. If a user does not have access to an object, you are going...
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
July 23, 2009 at 9:53 am
torpkev (7/23/2009)
I think I've been relying on the maintenance plans a bit too much lately (time constraints more than anything).. i think i'll just bite the bullet, mark off...
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
July 23, 2009 at 9:45 am
Are the tables in your sub-queries schema qualified? If not, is it possible that user has one or more of those objects in it's own schema that does 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
July 22, 2009 at 4:55 pm
Yes, you get everything in the transaction log. If you reach the max size that you have set - then your system is going to stop until there 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
July 22, 2009 at 4:53 pm
torpkev (7/22/2009)
I tried the view history, it was truncated.. that was my problem. I'll check those tables out tomorrow morning.Thanks
The history that you checked was from the job 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
July 22, 2009 at 4:31 pm
Where you are looking at the history is on the job - you need to look at the history for the maintenance plan. Right click on the maintenance plan...
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
July 22, 2009 at 2:21 pm
Yeah, that's what I thought you were doing - and at least for my immediate manager reporting on the actual server name would be better. But, either way works...
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
July 22, 2009 at 11:22 am
If this is causing you a problem and you can't get them to stop - you can always set the trace flags to make those options noops instead. Review...
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
July 21, 2009 at 5:22 pm
Looks very good - I like it. One small change you might consider:
Remove @server variable - replace with @@servername global variable. That is, if what you want 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
July 21, 2009 at 2:53 pm
Viewing 15 posts - 4,786 through 4,800 (of 6,676 total)