Viewing 15 posts - 4,891 through 4,905 (of 6,676 total)
GilaMonster (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
Yes...
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 1, 2009 at 8:46 pm
Yes, exactly - once you restore or attach a 2000 database to a 2005 instance, that database is converted to 2005. You cannot then later backup/restore that database 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 1, 2009 at 3:25 pm
Lynn Pettis (7/1/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
July 1, 2009 at 2:54 pm
Lynn Pettis (7/1/2009)
Using Processor Affinity they may be able to configure SQL Server to use only the cores in one physical processor which should keep them legal.
I don't think this...
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 1, 2009 at 2:39 pm
In addition to what Gail has stated, the default for new databases in 2005 is CHECKSUM.
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 1, 2009 at 2:10 pm
You really need to verify that you can modify SQL Server and still be within your license. I do not believe that you can 'throttle' SQL Server in 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
July 1, 2009 at 2:00 pm
Gianluca Sartori (6/30/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
June 30, 2009 at 4:02 pm
You are welcome.
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
June 30, 2009 at 2:56 pm
When you take a resource group in a cluster offline, all resources in that group are taken offline also. They are not failed over, which means the services are...
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
June 30, 2009 at 2:08 pm
I wouldn't think you would want to do that on Vista. If you are running on x86 hardware, then the maximum memory you are going to be able 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
June 30, 2009 at 1:35 pm
If you are installing on Vista or Server 2008 - you will get a warning message that this program has known compatibility issues. You will be given the option...
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
June 30, 2009 at 10:38 am
Correct - the latest service pack for SQL Server. The RTM version of SQL Server 2005 is not compatible with Windows Vista or Windows Server 2008. You will...
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
June 30, 2009 at 10:01 am
river (6/30/2009)
What about if i didn't had any SPs installed yet on my SQL Server 2005 developer edition with vista OS? by default the builtin\administrators have sysadmin permissions...
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
June 30, 2009 at 9:35 am
klnsuddu (6/29/2009)
Thanks for all your help...and one more question: does we need to give the backup path as
\\VirtualserverName(instead of Node name)\Z:\logshipping_backups_out in Log shipping wizard backup settings page?
If...
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
June 29, 2009 at 9:14 pm
klnsuddu (6/29/2009)
Thanks for all your help...and one more question: does we need to give the backup path as
\\VirtualserverName(instead of Node name)\Z:\logshipping_backups_out in Log shipping wizard backup settings page?
If...
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
June 29, 2009 at 9:10 pm
Viewing 15 posts - 4,891 through 4,905 (of 6,676 total)