Why you don't try to add secondary log file in the new location of your harddisk?

So, you just need to add your harddisk and add a secondary log file.

select * from sysobjects where type='K'

look in field crdate and the name of your index.

in the sample K means primary key.

select * from sysobjects where type='K'

look in field crdate and the name of your index.

in the sample K means primary key.

Create DTS in your SQL to export data from your SQL to access, you can use a DTS wizard to do this.

I think the good ways it's use the Log Shipping, because Log Shipping do not need a lot of resource (performance), and Log Shipping designing for DRP, but replication designing...

If you don't save the transaction log file, change the database recovery option to simple (not full), if you want to solve force, detach your database, delete the log...

You can create trigger for inserting.

http://www.mssqlcity.com

Database access tabs used to define the database access for current user, so if you have more than 1 database, the user must be specified to access the database, and...

In the EM go to security->login.

Yes you're right, every object must be transfer to

You need to re-setting the database configuration, if you want a database can run faster then before. But if your database has been setting in the good configuration before, you...

You just do the full backup database in SQL 7 and then restore in SQL 2000.

Try to captured on failure in your DTS Package

Check the services account for startup SQL services, if you want to using the windows authentication, change the services account using domain user, don't use local system account.