Read this.

Managing ransaction Logs[/url]

forsqlserver (6/7/2011)

---

Shrink Creates Fragmentation, U can use other ways to shrink the database.

check the mdf,Ldf size,

Take a full backup,

Change the recovery model to simple,

again do a full backup,

check the ldf...

GilaMonster (6/6/2011)

---

Yes, l replication needs a key, but it...

GilaMonster (6/6/2011)

---

muthukkumaran Kaliyamoorthy (6/6/2011)

---

@sqlzealot-81,

What gail told is

An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an...

One thing leads to another. Your code worked. Now I have additional questions. When I restore GMF to A as I did origianlly using SSMS, shouldn't I be changing the...

GilaMonster (6/6/2011)

---

Only if your...

You have to give the correct logical name to the restore clause otherwise the SQL will not take/create the database.

Lets try

RESTORE DATABASE B

FROM DISK = 'D:\SQLData\A.bak'

WITH REPLACE,

MOVE 'GMF' TO 'D:\SQLData\B.mdf',

MOVE 'GMF_Log' TO 'D:\SQLData\B_Log.ldf'

Gail

Thanks for your test results.

Gail

This means if i have primary key (C.I) then the SQL will do the delete followed by an insert to the table and PK.

Can you post me the result so that i 'll help you. (From Server B restoring server)

RESTORE filelistonly FROM DISK = 'D:\SQLData\A.bak'

alnawrass2002 (6/6/2011)

---

I have problem with one of our Applications,

The application acting very slow,and the developer say that this is due to SQL DB Server,how can i prove that SQL server...

LutzM (6/6/2011)

---

The easiest way to verify it would be to add a AFTER UPDATE trigger to a test table and insert the results of the internal DELETED and INSERTED tables...

WolvesAly (6/3/2011)

---

Hi all

I am new to here and just getting into SQL 2008 . Does anyone have any pointers or simple steps for me to import a database into...

Gail, Got the link

UPDATE Statements May be Replicated as DELETE/INSERT Pairs