Viewing 15 posts - 5,236 through 5,250 (of 6,676 total)
I don't know of any way to disable the message - but, if it is that annoying then they could always script out the table definition and make the modifications...
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, 2009 at 2:53 pm
I believe you had to have SSIS installed on pre-SP2 SQL Server 2005 installs. Might have been SP1 that changed this - but, I don't recall.
Definitely post SP2 2005...
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, 2009 at 2:27 pm
I would look at WMI settings on the server and the laptop. SSMS uses WMI to connect to the server and to perform service start/stop etc...
I have seen issues...
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, 2009 at 2:13 pm
Okay, there are a couple of issues with your plan - but I'll get to that later. The Maintenance Plan cleanup task has several options that need to 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
April 27, 2009 at 12:51 pm
Rudy, have you seen any differences if there are more CPU's available? I have not seen a large difference between using 3 threads and 7 threads with 8 CPU'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
April 27, 2009 at 11:52 am
William,
Yes - if you have other applications running on the server - you need to size the page file according to the requirements for those applications. I have never...
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, 2009 at 11:09 am
liuwilli (4/27/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
April 27, 2009 at 10:36 am
How is the task setup? What is the value you put for the file extension? Are the backups in separate folders for each database? If so, did...
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, 2009 at 10:08 am
Why would you switch from simple recovery model to full recovery model to rebuild indexes? You should already be in full recovery model and performing transaction log backups on...
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, 2009 at 10:06 am
Because tempdb is recreated during a restart - you could delete the current tempdb files and let SQL Server recreate them during startup.
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, 2009 at 9:48 am
SQL Server and Agent - and any other SQL Server related services are just that - services. There is no reason to log into the server to get them...
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, 2009 at 9:32 am
How many CPU's on this server?
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, 2009 at 10:57 am
SQL Server 2005 x64 Standard will show memory pressure issues. I am not sure where the cutoff is for it, but I have seen some installations with 8GB of...
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, 2009 at 9:07 am
Glad I could help - 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 24, 2009 at 7:44 pm
RESTORE HEADERLISTONLY FROM DISK = '{your tlog backup file here}';
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 24, 2009 at 3:37 pm
Viewing 15 posts - 5,236 through 5,250 (of 6,676 total)