Viewing 15 posts - 5,116 through 5,130 (of 6,676 total)
If you add additional columns to the output, those changes will show up in SSIS but will not do anything. The new column(s) are ignored in the data flows...
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 5:24 pm
Did you update the catalog on SQL Server 2000 by execute the instcat.sql file from the 2005 instance?
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 4:32 pm
Nathan Davis (5/26/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
May 26, 2009 at 4:26 pm
As has been noted in various articles and blogs - SQL Server does not like to give up memory once it has it. With this change, what will happen...
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 2:34 pm
To add to what Jonathan has stated - find out if those LUN's are being presented from shared volumes. In other words, are the volumes (and disks) dedicated 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
May 26, 2009 at 2:31 pm
One more thing - moving these tables to another database will require that the foreign keys be removed and managed through triggers instead of contraints. Make sure you understand...
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 2:14 pm
How are you referencing those tables in your code? There might be a way to move those tables without re-coding. You could try creating a synonym for 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 26, 2009 at 2:11 pm
Glad we could help and you were able to get it set. Jonathan was spot on with regards to x64 - and the requirement to set the max memory.
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 2:04 pm
Execute just sp_configure. Scroll down in the results and find the setting for max server memory. Copy that entry into your command, which will be:
sp_configure 'max server memory...
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 1:46 pm
Steve, I guess that answers the question then. At least it does for me 😀
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 1:39 pm
Okay, you are talking about the steps to perform in a maintenance plan.
For system databases, you need the following:
Integrity Check
Backup System Database
Cleanup old backup files
The above should be...
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 1:38 pm
Krasavita (5/26/2009)
In what order jobs are running?
I don't understand the question. What jobs - what order?
I have a maintenance plan for the system databases, and a separate plan for...
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 1:12 pm
You can think of the schema as the container that objects belong to. I would recommend reviewing books online on the subject because there is much more to it.
When...
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 1:07 pm
I setup separate maintenance plans for system databases and user databases. They are independent from each other.
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 1:00 pm
Not sure about reporting services - but, you can try changing the windows identity in SQL Server Configuration Manager.
When the system was renamed, you probably have the old IUSR accounts...
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 12:59 pm
Viewing 15 posts - 5,116 through 5,130 (of 6,676 total)