If you don't want that database in dev machine the easiest way is to detch in dev insance and attach in prod. Else take a back and restore in prod...

What is the size of model database? Also check if there are any procedures running with hash table being called.

I meant have the database @ server a and install the report server components and the report server website directories @ server b. I hope i have explained what you...

Can you post us the error that you get while running the MP.

When i meant by windows native backups i mean that use the ntbackup utility to backup the OS files to the tape so that you can restore them. Veritas backup...

Check the size of the log file.

Yes temp table. But suggest to properly index them on creation so that they does not hit your query performance.

I too am interested in knowing this the old licensing method in control panel does not seem to appear in sql 2005.

I don't think so you can set timeout at DTS level you have to set it @ the server level.

You will not be able to restore log backup for master database btw you would not be able to back them up too. how did you take a log backup...

I am not sure if i understood your question correctly. But

1. If you are taking the database files to tape without taking a db backup then you might need the...

Also set up and alert when the sql service goes down so that you know your service is down and can do something

What is the RDBMS that you want to link to. IF DB2/ORACLE you need to have client compenents installed. IF sql server then you can use sql native client to...

Now drop the logn and recreate it using SSMS and then grant access to the database and try logging into the server using that login

backup log dbname with truncate_only

go

dbcc shrinkfile(logfilename,100)

check if this helps.