Viewing 15 posts - 5,101 through 5,115 (of 6,676 total)
Why are you trying to make this dynamic? If you are extracting data from one system and loading it into another (ETL process), you really need to have 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
May 27, 2009 at 2:51 pm
That depends on when you are scheduling them. If they are part of the daily maintenance, then it would come after the integrity check. If they are scheduled...
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 27, 2009 at 2:46 pm
As Steve has stated - the commands are what I stated. Definitely review books online for further information for all of the commands.
I really don't have a script available,...
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 27, 2009 at 2:41 pm
Are you now backing up the transaction log on a regular basis?
Verify the recovery model of the database. Is it full recovery or simple?
If simple recovery model, shrink 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
May 27, 2009 at 10:58 am
What have you tried so far? Have you taken the time to read the article I link to in my signature? Have you taken the time to read...
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 27, 2009 at 10:50 am
I would recommend using synonyms for this. You have to define each object that you are going to reference, but it is very easy to create and modify later...
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 27, 2009 at 10:33 am
As others have stated, lookup row_number() in books online and also read the article in my signature. It will show you how to post your questions in a way...
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 27, 2009 at 10:10 am
Pradyothana Shastry (5/27/2009)
use the followingBackup log with truncate_only
dbcc SHRINKFILE(DBNAME,0,Truncateonly)
This is very bad advice to give, unless you want to break the log chain and destroy your ability to recover...
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 27, 2009 at 10:04 am
For database mirroring, yes you have a full copy of the database on the other server that is unavailable because it is recovering transactions. However, with Enterprise Edition 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
May 27, 2009 at 9:55 am
You need to update the usage on that database. I would bet anything the database was upgraded from SQL Server 2000 and you have never run an update usage.
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 27, 2009 at 9:19 am
Grant Fritchey (5/27/2009)
AShehzad (5/26/2009)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.Are you sure? 😉
Yes, statistics are updated after rebuilding the index...
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 27, 2009 at 9:11 am
You are running into the double-hop problem. If you require Windows Authentication to work you are going to need to setup and configure kerberos for the service line account(s)...
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 27, 2009 at 9:00 am
Kupy, yes that would probably be a good idea to correlate the exists query back to the customer. It definitely would have been seen with sample data 😉
Edit: Sorry...
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 27, 2009 at 8:26 am
Okay, then I would go with Gail's recommendation of 12GB max memory. You don't want to go higher than that, well maybe 13GB would be okay - but, you'll...
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 27, 2009 at 8:21 am
Sure, there are a couple of options:
1) Database Mirroring and Database Snapshots (requires Enterprise Edition on the report server)
2) Transactional Replication - requires identifying specific tables (articles) to be published
3)...
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 26, 2009 at 8:29 pm
Viewing 15 posts - 5,101 through 5,115 (of 6,676 total)