As already posted, the restore will first create the database files, then do the restore. You may be able to save time on the database create by exploiting 'instant...

If you use any automated method of moving DTS packages you will loose the package layout and annotations seen in the original package in DTS Designer. The package will...

Thanks Eduardo, it is good to know that the import wizard also gives you editable DTS.

You mentioned the KB 345170 fix, but have you also seen KB 917406. This...

My recollection is that the HF 2187 apply process stops and starts the SQL instance.

There are 2 ways of getting SQL 2000 DTS packages into SQL 2005 or SQL 2008. One wraps the package in SSIS and means the package cannot be edited....

Gail, I think you need to review what Microsoft says about the /3Gb and /PAE boot.ini switches...

/PAE activates the Windows addressing extentions that allow appilcations to address more than 4GB...

The marketing hype around the digitial butler always assumes the information the butler has is correct, and that no-one will misuse that information.

The reality is the data quality is always...

It is almost impossible to get zero fragmentation on an index, especially if it is a non-cluster index.

The fragmentation value is telling you how many non-contiguous chunks of extents you...

You need to get together with your storage administrator. If you know nothing about how data is laid out in a SAN and the SA knows nothing abuot databases,...

I'm going back to Andras' post.

If you want to spilt the adderss 'Upper 4 - 8' you really do need to know the actual addresses used in 'Upper'....

I have not heard of any issues about this.

If you do not hear from anyone else in the next 2 days who has a solution to your problem, my recommendation...

The paging file can be split over multiple drives. At my old place, all drives were on the SAN except for 1 local drive. The local drive was...

This normally means the account you use to run SQL Agent does not have logon rights to SQL Server.

I often find EM Current Activity hangs when the server is busy, especially if there is a lot of blocking happening.

You can use QA and sp_who2 to get...

And a bit more, slightly off topic... If you use Dynamic disks, then you must also have the 'Bypass traverse checking' windows right. This is because the root...