Are you sure you had 5 mlf files?

Is the following link helpful?

http://support.microsoft.com/kb/276992

Here is my guess. You have more than one chanel to dump data to your database. In log shipping, your database is waiting for logs with right lsn. If you...

Based on my experience, you may consider the business intelligence (BI) design. However, based on your description, your database is not huge at all. I believe a regular design should...

After the first condition for CASE is met, the execution jumps out from the CASE. That is the reason why you obtain those results.

sp_grantlogin

An interesting question. I would like to know the answer, too.

master database is used mainly for security. If you do not have any change in this server, you may not backup this database every day. But you should backup this...

You just need to give a desired database name and change the file paths in your restoring database. It is very easy to follow in EM.

I had the same eperience. I had to drop the database and re-restore it.

MSDB

Detach, copy, attach.

You need him privileges to access to sysjobs, sysjobhistory, sysjobsteps. 

I do not know if we can asssign each database with different port number. But if you would like to know the port number of network configuration, you can

Open the...

The answer is yes.

To trace login, use master..sysxlogins;

To trace users, use sysusers and sysprotect in each database;

Add triggers on these tables.