Viewing 11 posts - 31 through 41 (of 41 total)
Yes, That defeats the whole purpose of clustering. If the machine with the two instances has a hardware failure. Your whole cluster fails. Where if you had two seperate physical...
August 4, 2006 at 3:35 pm
After backing up your transaction log (providing you have enough space to back it up or even care to back it up)
You can also do the following to shrink the...
August 4, 2006 at 3:30 pm
When the Publication was created there was a step called "Snapshot Agent Security". On this step there two things that deal with accounts.
First: Run under the following windows account. OR...
August 4, 2006 at 2:51 pm
My Documents\SQL Server Management Studio\Projects
July 21, 2006 at 4:29 pm
I was able to get this working using the same names but I had to also drop the subscription database.
Thanks!
July 20, 2006 at 2:53 pm
I got this to work from a different SS2000 server to the same SS2005 that I was trying. Now I'm in the processes of figuring out what is different between...
July 14, 2006 at 11:58 am
Always try to avoid Raid5 when dealing with databases. Raid 5 = slower writes.
July 4, 2006 at 4:04 pm
Search the books online documentation for "SQL Mail" it will tell you all of the requirements needed to use this feature of SQL Server 2005.
Thats a typical MS "hose and...
June 30, 2006 at 1:30 pm
If it was that easy there there would be no DBA's
However there are several good books on what your looking for.
The Microsoft SQL Server 2000 DBA Survival Guide
June 30, 2006 at 1:14 pm
"we still need to use SQL Mail and have a new SQL 2005 install."
They key there is "a new"
By default SQL 2005 has several services disabled. If you read...
June 30, 2006 at 1:04 pm
If you want an automated failover system then you want to use database mirroring.
June 29, 2006 at 8:00 am
Viewing 11 posts - 31 through 41 (of 41 total)