I also heard from our Oracle DBA's that Oracle RAC is Amazing....

We have system database's mdf, ldf and user databases mdf files on one drive and user databases ldf files on other drive.

The reason for going to a have a separate...

The DTS package we have is very complex one and has ActiveXscript tasks and Dynamic properties Tasks. So for time being, we just want use the same DTS in SQL...

Because if we use either primary or secondary server instance as Monitor server, the performance will be Degraded. I do not know much this will impact on the performance. So...

Its not a 3rd party...

could you please tell me how to achieve step 6...

6)We have 10 databases in the primary server instance and we are configuring log shipping for only one database.

Now how to script and transfer the users and logins related to...

Hi Gail,

I have one question regarding the restore of a database from a Backup device, which consists full, diff and log backups in it.

Scenario:

1. We have the backup device called...

Neither. My personal preference is that each backup goes to an individual file that has the date and time as part of its name

2.Backing up the Full to Z:\Backups\Full\prod.bak

Backing up...

thank you,

We are backing up the full, diff and log backups to the same backup device. In order to recover the database to the last transaction log, I followed...

Hi,

We are backing up the full, diff and log backups to the same backup device. In order to recover the database to the last transaction log, I followed below steps:

1.Restore...

Could you please advice how to make it work?? I'm not getting an email when executing the procedure usp_DiskFreeSpaceAlert

Is the above backup strategy makes sense??

We have Separate disk for Backups. Data, log and Backups are on different drives and all the drives are on SAN.

any advice please....