Try using sp_attach_single_file_db. Below is the syntax.

sp_attach_single_file_db [ @dbname = ] 'dbname'

    , [ @physname = ] 'physical_name'

I believe you will have to drop and re-create the tables. Enterprise Manager has on option to change the filegroup but if you run a trace in the background, it does...

you can have something as simple as below.

create table test (column1 char(100))

declare @i int

set @i = 0

while @i < 1000000

begin

insert into test values('a')

set @i = @i + 1

end

drop table test

Check this article.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_clustering_084y.asp

select * into tableB from tablea where date < ''

 --if you don't have tableb created

Insert into tableb select * from tablea where data < ''

-- If tableb already exists.

The file_name under data files tab is the logical file name. This should be fine. The location gives the physical file name.

Yes, Select to install SQL server on the Local computer instead of the virtual server.

Can you check value of the column originating_ server in sysjobs ? If it is different than the servername, you can update sysjobs and set it to the servername. This is...

The command "The command(s) completed successfully" is being generated from Query Analyzer and not from SQL Server. I'm not sure what issue you are having but if you type in...

I don't think SAN is a requirement. The only requirement is that the disk should be shared and should be seen by both servers.

what do you have as the data source ? Can you post the output of sp_linkedserver 'lnkservername'

Depends on how often you do your dataloads and fragmentation. We do ours once a week. You can check your fragmentation by running DBCC SHOWCONTIG.

You can do the below.

declare @where varchar(100)

set @where = 'name = ''sysobjects'''

declare @sql varchar(200)

set @sql = 'select * from sysobjects where ' + @where

exec(@sql)

How often do you backup the log file ? Full backups will not truncate the transaction log file.

Below has some explaination

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=150357#bm150543