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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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 !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 23, 2005 at 12:37 pm
here's a website you'll probably bookmark: http://www.connectionstrings.com/
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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 ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 23, 2005 at 12:25 pm
death is not a constant, it is a state, a change in the state of existance ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 23, 2005 at 11:43 am
Change is the only constant of existance ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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 ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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 ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
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 !!!)
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 23, 2005 at 10:45 am
Viewing 15 posts - 1,891 through 1,905 (of 2,436 total)