From my point of view, time saving is the most critical piece in justifying purchasing of tools like this.

If I goto my boss that I need a tool & If...

By the way, I have upgraded from 760 to 818 (in most cases).

I have installed this hotfix on different machines. But I have downloaded into d:\DBA\Software\Fixes\8.00.0818\SQL2000-KB815495-8.00.0818-ENU.EXE. Then extracted using Winzip into d:\DBA\Software\Fixes\8.00.0818\SQL2000-KB815495-8.00.0818-ENU\*.*.

Then I installed. I did not get that error. I have...

Most of the vendors will offer the Backup with pretty fast timings. Because this backup is not from SQL Server. Its from their console software & hardware drives. Pretty amazing actually.

If you goto SAN's the SAN manufacturers will offer seperate solutions for backup, recovery, standby, hardware mirroring, etc.

You are welcome!!! Glad your problem resolved.

I have been using DBArtisan since 6.0. The all new 8.0.0 version is awesome. Though the readme says that they support from SQL Server 7.0, 2000 and higher, You can...

Did you try xp_smtp_sendmail? Its free & flexible. I have been using this morethan a year. Pretty neat.

Here is the link. http://sqldev.net/xp/xpsmtp.htm

For this, You would need to register...

Initially I had thought about putting logs on RAID 10, but then wanted to see the performance increase on this... Thats the only reason I was thinking about RAID 0.......

Or is there any rule or contition that we must have the same version and edition of Windows for Pri and Backup servers, while implementing Log Shipping / Replication??

Please advice me...

Can you try using "sa" account? Must be something to do domains...  But you should be good to go with "sa" account registration...

Can you also check how you registered this SQL Server from MMC?

Is it using "sa" or Windows NT? Are these two boxes in two seperate domains? 

To my understanding, If you register that server using Windows Authentication (Trusted) you need Local Admin rights on the server to be able to edit this option.

Thank You stacenic.

We are already running ENT Edition on Production Server. We are trying to setup standby server to this using either ENT Edition OR STD Edition.

Just a thought... We...

I did have similar issue recently, when I created a user (SQL user) and did grant db_datawriter. This user could not SELECT any data. So I gave db_datareader as well... and...