SecondaryFile is the logical name of the 2nd file in the primary filegroup which you want to remove.

In this case you can use emplyfile parameter in dbcc shrinkfile

Use Mydb

dbcc shrinkfile(SecondaryFile, emptyfile)

--2nd file has been emptied, now remove that...

nitin jain (9/4/2009)

---

hi all

i hav one database backup file which contain 2 mdf and 2 ldf file. now i want to restore it with 1 mdf & 1 ldf file,...

If the management doesn't listen to technical voices, nothing much can be done. You got to continue with the DT software... It looks like copying the entire file system/or select...

Henrico Bekker (9/4/2009)

---

no its basically just mdf and ldf replication.

the app doing the replication couldn't tell the difference between a mdf or a mp3 😛

it's replication is amost real time,...

Henrico Bekker (9/4/2009)

---

Hi All, need some suggestions...

Scenario:

For our DR site, we are using Double Take for Replication between sites.

File replication.

Now some weeks ago, with a DR Test replication some how...

Refer Books Online. There are many articles on net as well. You may want to search them too.

Poor performance could be due to poorly written queries. The following two articles by Gail will help you track down such queries which you can fine tune.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

IF @frag = 30.0

SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';

You are checking in these lines whether...

No. It doesn't.

When a clustered index is created on a heap, the heap is arranged based on the key so the table size should remain more or less same.

In non-clustered index,...

When you perform constant insert/delete in a table, the associated indexes become fragmented. The process of removing this fragmentation so that index pages become contigous is called defragmentation.

You'll find ample...

It's a vast topic. I suggest you start with Book Online.

Here [/URL] is a...

Once you have created the login, you can provide specific privilages for databases to each developer.

If you provide specific privilages to the group, all users will have same privilages.

Instead, Add each NT ID as a Login and provide rights to access a specific database(make that...