I think you are viewing this 28MB figure against sqlservr.exe under task manager. Is it?

Manu

Please change

from

select @VHO_Name = LEFT(@@servername, 6)

to

select @VHO_Name = LEFT(@@servername, 15)

Manu

Do you have access to source database? If yes, try running DBCC CHECKDB on source database and verify if that is fine or not.

Manu

Why don't you specify the complete server name. half name is not allowing SQL Server to recognize the mentioned group.

Manu

Whats your workstation name?

Manu

Terry,

Did you tried this:-

1. Create a database with the same name in another directory as the one you're trying to attach.

2. Re-create all filegroups and files as necessary & then...

This script will work for me. Thanks a lot Carl.

Manu Jaidka

Can you try the same by creating only one index(Clustered Index) on these three columns and then start the data loading process?

Manu

Do this table have any foreign key references or constraints refering it?

Manu

You are right Chris as it won't delete any backups apart from SQL native ones.

Manu

If this is the first time you took backup to two files then use the code mentioned below:

Use msdb

select media_set_id from backupmediafamily

group by media_set_id

having count(media_set_id)>1

select Physical_device_name,* from backupmediafamily...

I dont have answer to your first question. Please find attached doc describing encryption a bit. Yep, u r right that is known as key management and it has been...

As per books online explanation about DBCC SHOWCONTIG heaps fragmentation is never reported. Also, heaps can never be defragged. Only one option is thr to defrag them:

Drop and recreate the...

If you have time please go thru this nice document:--

http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/

Clustering SQL Server 2000 from 500 Feet.

Although urs is 2005 but concept of Active and passive configuration is still the...

I just meant that statistics are automatically created on columns used in a predicate. Adding statistics improves query performance because the SQL Server query optimizer can better determine how to...