Viewing 15 posts - 1,891 through 1,905 (of 2,436 total)
You have one viable courses of action available that I can think of.
Restore from the last clean backup - yes data loss will occur but there will be no corruption...
September 23, 2005 at 1:06 pm
Yes. Exactly.
G: drive --> Meta-LUN for database data, striped across 3 LUNs
H: drive --> Meta-LUN for transaction logs. striped across 5 LUNs
I: drive --> Meta-LUN for database backups, striped...
September 23, 2005 at 12:57 pm
As remember from my youth, the only 'certainty-s' were: Death and Taxes.
Now the information age has added another 'certainty': The computer will crash !
September 23, 2005 at 12:50 pm
Failover has various phases: IP address, storage, services then SQL Server startup. In a Win 2K3/SP1 w/SQL 2K/SP3, I can see a complete 'failover' taking 3-5 minutes. Our clusters generally are...
September 23, 2005 at 12:37 pm
here's a website you'll probably bookmark: http://www.connectionstrings.com/
September 23, 2005 at 12:27 pm
One 'biggie' commonly missed is also the JOBs that the SQL agent executes. DTS and bcp also come to mind ...
September 23, 2005 at 12:25 pm
death is not a constant, it is a state, a change in the state of existance ...
September 23, 2005 at 12:23 pm
SQL Server service account should not be LocalSystem nore local computer accounts. They need to be domain user acconuts that are in the LocalAdministrators security group. As an additional security...
September 23, 2005 at 12:04 pm
In order to monitor things (what you are doing and more importantly what is going on) you have no choice but to make him a sysadmin <period>. After all your...
September 23, 2005 at 11:51 am
Integrated security should work if, and I say if, the user logs into the domain via 'normal' means. In other words either your VPN has hooks into AD or the...
September 23, 2005 at 11:43 am
Change is the only constant of existance ...
September 23, 2005 at 11:33 am
I do not know if adding WINs would make a difference. We use DNS and WINs as standards here.
How much time are you talking abut having to wait anyway ?
September 23, 2005 at 11:26 am
If this is a scalability test then should't you be using quad CPUs and 4 Gb of RAM ?
September 23, 2005 at 11:11 am
All is well. Just continue and apply the service pack after the initial installation reboot. Here's the KB link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;329329
September 23, 2005 at 10:48 am
Excellent points Philip. I'd forgotten about some of those hidden 'nasties' lurking in DRI ...
(I've got to review SQL 201 again !!!)
September 23, 2005 at 10:45 am
Viewing 15 posts - 1,891 through 1,905 (of 2,436 total)