Could you please to specified the error message?

You must check your server name before create the publication, please check with @@SERVERNAME, the server name must be in the list.

If the server name not in the list, you...

Yes, the xls file must in the server, if the xls location in the local machine, of course, you must create script to uploaded xls file to the web server.

1. select * into TableB From TableA

2.

For all of them:

ALTER TABLE tablename

DISABLE TRIGGER ALL

For a specific trigger:

ALTER TABLE tablename

DISABLE TRIGGER triggername

Change the database option to truncate log file on checkpoint

Why do not try to use DTS?

You just restore database with recovery option, but make sure all backup has been restore to that database.

Please see this :

http://www.sqlservercentral.com/scripts/contributions/1092.asp

Yes, because the query statement doesn't need to wait until the user release the record from the locking process.

For example :

TableA has a 100 records, record number 40 has...

Delete one of your log file, so after that you can dettach and attach again your database with only one log file

If you just want to query the data in the table, try to add "NOLOCK" option in your query statement, because with this statement if someone lock that record the...

Like you sad before, the tape drive it's a good choice, but try to split the tape by year or month, because it will help you, in case you need...

I think you need to split the database into a couple database or into 2 database, because like you say, you don't need the data readily available.

You can create a...

I think you must detach your database, after that delete the log file and then attach the database. (This way will create a new log file)

I think you must detach your database, after that delete the log file and then attach the database. (This way will create a new log file)