The restore makes a 100% exact copy of the db at the time of the end of the backup.

So if the prod db on server have has 100 GB of...

FTI is not my forte, and unless Gail studied it last week, it's not hers either afaik.

Did the other thread end or are you still getting replies?

No harm done. I just wanted to make sure that this point was 100% clear :-D.

SELECT GETDATE()

ssk0507 (9/26/2011)

---

Just it took 30sec to complete. I am feared it goes to any problematic ?

I did say this thing to my manager

Please give me a suggestion :

can...

I'm no asp expert. That setting used to be in the command or dataset object.

However I think you'll be getting a page or server timeout well before your ds...

It shrinks the log to 55 000 MB.

You lose any hability to do point in time recovery untill you redo a full backup.

No users can login and you kick everybody...

We did demo code, you need to...

No the setting is timeout.

How about we fix your code instead??

Can you post the tables definitions, including keys and indexes and most importantly the actual execution plan?

Ninja's_RGR'us (9/26/2011)

---

DECLARE @demo TABLE (ID SMALLINT IDENTITY(999, -1) PRIMARY KEY CLUSTERED, sometext VARCHAR(50))

INSERT INTO @demo (sometext) VALUES ('one')

INSERT INTO @demo (sometext) VALUES ('two')

INSERT INTO @demo (sometext) VALUES ('three')...

What do you have now?

Is the performance acceptable?

What's the growth you have to account for & over what period?

How long is that server supposed to last?

INSERT INTO msdb.dbo.DBA_CheckDB

EXEC ('DBCC CHECKDB(''master'') WITH TABLERESULTS, NO_INFOMSGS, ALL_ERRORMSGS')

UPDATE msdb.dbo.DBA_CheckDB SET DbName = 'master' WHERE DbName IS NULL

IF @@ROWCOUNT <> 0 --corruption in DB, disable jobs, warn admins

BEGIN

EXEC msdb.dbo.sp_update_job @job_name=N'Delete...

Ok, je vais traduire si tu ne comprends pas.

saqibshakil (9/26/2011)

---

I am facing a similar problem

"The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed"

using a Project with VB6 and ADO without any linked servers. Can you...

Did you actually try to understand the exemple I posted?