Sorry. BOL means "Books On Line" which is the help documentation for SQL Server.

I don't recommend a VMWare instance for a production SQL Server. A virtual machine only gets a portion of disk space, memory, and CPU so performance isn't very good....

When you say the statement below, you were basically rebuilding Log Shipping every weekend.

Backup;

Copy and Restore on Secondary;

Start applying Logs on Secondary.

When you have a very large database, rebuilding Log...

What I've had to do is split up the reindex or defrag jobs so that there aren't so many large log files to ship to the secondary. I put...

We run server-side traces on all of our SQL boxes for auditing purposes, and I am amazed at how little the systems are impacted. They run 24x7 on SQL...

I'm glad to see this topic discussed. We have the same problem here that anyone who can say 'sequel' ends up requesting Management Studio, Enterprise Manager, or Query Analyzer....

I've run across the same problem with Log Shipping, but sp_help_revlogin makes it easy.  Just create the procedure on the primary database server (in master) and run it in Query...

First run "select * from sysobjects where replinfo = 1" to see if replication still exists.  If so, run sp_removedbreplication.  You might need to enable replication in SQL Server first. ...

We too use Remedy for DBA requests--I insist on an email request first so that I can copy & paste the information myself.  This way I can sort through them...

I tried SQLZip and it worked fine on smaller databases.  When I used it on large, busy databases with sets of 2 or more files the restores errored.  I don't...

You may want to adjust the schedule on the job that copies the files so that you can control which files are actually restored.  Or you could probably rename the...

I agree that log shipping should work.  I have a similar situation where the server B needs to have data as current as 4 a.m. and the database needs to be available...

You also need to make sure that the protocols are enabled.  Go to the SQL Server Configuration Manager under Configuration Tools and make sure that TCP/IP and Named Pipes are...

I don't know why you would want to close any of the connections--are they causing any problems?  I see connections from the various BES services or applications for synchronization, messaging,...

I see that you switched from Oracle 9i to version 10--that's good.  We had version 9i on a SQL 2000 cluster and there were issues with that particular driver (mostly...