Create the replication folder manually first...

Then cleanup your database and its publications and subscriptions if any exists...

If you have replication script use it to recreate it otherwise do it through...

Can post your backup device details...

I think you may be using the backup device file name same as your database mdf file...

I don't think there is any build in solution for this...

You have write your own...

You set the database alerts to get the notification when db corrupted...see bol topic "How...

Can you explain what is the exact problem...

and check your log file in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG folder for more info...

Don't allow any one to restore production database copies to their laptops including power users...

Don't give the access to your backups to regular users other than power users...

You can enforce...

Bob,

You can post this in one place and ask moderators to make it sticky instead of posting in all topics

I don't use Red-Gate...

Tempdb can't be restored or recovered...

Tempdb gets recreated every time when restart sql services...

You have to use Alter database tempdb....

Check the settings for MSDTC under Component Services.

How to enable network DTC access in Windows Server 2003

http://support.microsoft.com/default.aspx?scid=kb;en-us;817064

After sql installation, if you have the backup of MSDB database you can restore on top of new msdb database...

When you restore msdb database you get all your dts packages,...

syspublications table is stored in the publication database...Make sure you are running in published db...

Are there any blocking either on subscriber and/or publisher?

Any errors in sql log or application log..

Run the sql profiler and see what is happening...

Take the cluster group offline which includes sql services, disks, ip address ect...

Try the following....

DBCC

CHECKDB ('dbname') WITH tableresults

I believe you can change with SQL configuration Manager...

How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port

http://support.microsoft.com/kb/823938

Why and how do you need to take the db offline when sql server is stopped.

Is your dbs in standby mode or loading mode?