Yes, it is too much time. Are you compressing the snapshot on generation? This will make SQL to last more in generating the snapshot.

With @sync_method are you using?. If...

In wich columns do tou have the indexes?

You could select top 1 from thatcolumnorder by desc.

Anyway you do it, you should use the indexes.

You won't be able to restore the production db in the publisher db if the db is alredy part of a publication.

You will have to drop the publication ,then...

If you have a table in a publication you won't be able to rename the table, unless you drop the publication, rename the table, and then recreate the publication.

...

Can you post the error message you recieve?

Did you used sp_detach_db in the source server to de attach the db, or you didn't deattached it?

You can use sp_tables, sp_help to know the tables and the datatypes of each column.

If you want to print to paper, then I guess you can create a table with...

We can't answer the question if we don't know the columns and the queries that use the table.

If I where you, I would let a trace running to...

Remove the no_output parameter, rerun the xp and post again the error message you get.

Can't be an SQL or service pack problem. You should check permissions or other setting.

We are running terminal and remote admin with SQL and the impact is not so high to stop using it.

you should also check the owner of the table, and execute the delete also with the owner

I recommend in every restore to use QA and learn and get used to use the tsql commands.

To restore the master db, I start sql server with sqlservr.exe -m parameter....

You also can simulate a transactional replication. You can add fields with datetime data types to capture the changes or create triggers of insert and update to also capture the...

If you mean a republicataion topology in wich the subscriber is also a publisher and the publishger is also a susbcriber it is no problem. That schema is the one...