Clark,

Database files won't get shrinked by themselves unless Auto Shrink option is enabled(which normally shldn't be).

Have you tried other options like compress pages and other available under enterprise manager...

Can you just check the fragmentation value for both the tables once?

Manu

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...