Snapshot to a different db and restore the backup of snapshot db on to the production db...

1. Snapshot replication...

2. Configure snapshot replication from ServerA.Testdb to ServerB.TestdbSnapshot

3. Backup ServerB.TestdbSnapshot

4. Restore...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=623113&SiteID=1

Looks like you have disk issue...

Run the check db first without delay...

Most of the cases related torn page, end up with database restore with previous good backup.

Did you resolve your issue? what is the solution?

Replication between the two domains in possible... as long as servers can connect to each other...

Is any of the server involved in replication registered as different name or aliased?

Replication creates...

You can make use of the following script..

set nocount on

declare @cmd varchar(500)

declare @db varchar(128)

create table #results(FileType    varchar(4) NOT NULL,

                      [Name]      sysname NOT NULL,

                      Total       numeric(9,2)...

How to send e-mail without using SQL Mail in SQL Server

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

SQL Server SMTP Mail XP

http://www.sqldev.net/xp/xpsmtp.htm

Generally this error happens when there is incomplete I/O operation...

Restoring from the backup is the best option in this case...

Is write cache enabled on disk/san controller?

Read the following article...

When backup log run with NO_TRUNCATE option also will not truncate the log..

Online indexing is done by creating the index side by side...

I am not sure but I don't  think there will any rollback time...

You can simply test it on dev server...

Post the script...

May be you are using new datatype which is introduced in 2005...

See the following article..you may get the solution..

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

Check this...

http://vyaskn.tripod.com/code/sp_show_huge_tables.txt

You don't need N' becuase you already declared fname as nchar...

-- Create a Queue

declare @rc int

declare @TraceID int

declare @maxfilesize bigint

declare @DateTime datetime

set @DateTime = (SELECT DATEADD(mi, 1, getdate()) )

DECLARE @FNAME...

I tried vaious options in replication. I didnt find the option "Keep existing data unchanged"; the option available in Snapshot is "Keep existing table unchanged".  I want a restriction based...