You need not create any file groups in the database2, I guess you are trying to overwrite the existing Database2.

Then it must be the case that you do not have the required permissions on the Database

The msdb.dbo.restorehistory Table has the info regarding the restorations done on that SQL Instance, check that out.

Good

If you have 2 Files and if both of them are in the same filegroup, then shrinking the 201 MB File and emptying it is the option to go.

USE [DatabaseName]

GO

DBCC...

Partial restoration of the Databases can be possible only using File group backups but not using Full backups, you cannot restore only desired part of a Full backup.

Very interesting question...

Well, according to my knowledge, SQL Server uses round robin procedure. When you try to insert the data into a table, it would use the 1st datafile until...

I feel there should not be any problems that arise if you empty the third datafile and delete it.

I understand the situation but would like to know how often are you planning to move the data from onsite to offsite.

We have a larger size of databases and doing...

I wonder that you could add another data file with the same logical name as an existing one.

I remember SQL Server does not allow to do it ( I...

I think you better send the table create Scripts for the Tables that you are talking,

which would be more easier to understand.

Yes,

Merely having Indexes will not keep the system at high performance, with the increase in the data...

Use Pivot table Functionality

The Installation of SQL 2005 will work on a Server which has SQL 2000 the vice versa is not possible. (2000 on a Server with 2005)

I have done it a...

Yes,

If you intend to use Database Engine only ( Not SSAS or SSRS) then install the SQL Database Engine not selecting the Client tools, workstation components and Development Tools.

And...