To use Truncate or not........

If you use truncate (with DBCC SHRINKFILE or with BACKUP LOG dbname WITH TRUNCATE_ONLY), you 'break' the backup chain and must start a new chain. That...

You say you can't restore the database. What error are you getting?

(By the way 'point in time' is used with LOG restores only. With 'point in time' you can restore...

You need to create a linked server connection between the two database servers. Then you will be able to work from one to the other.

Refer to the BOL for...

Oh. An important fact you didn't tell us.

I am sure you would have gotten better suggestions if you had told us this happened on a TEST system and not on...

What do you mean you want to hide it?

-SQLBill

You should have only restored two files.

1. The latest FULL backup prior to the 23rd.

2. The DIFFERENTIAL from the 23rd.

AND you should have restored the full backup using the command...

You can shrink the database file size by using DBCC SHRINKFILE command. Check the BOL for the syntax. You have to use the actual file name. To check what it...

Did you register the SQL Server instance? (In EM, right click on SQL Server Groups).

If you did, try refreshing.

Lastly, what version of SQL Server are you using (SELECT ServerProperty(ProductVersion)).

-SQLBill

It's a joke......tells you that if this happens: What happens if you lose the disk on your primary in the middle of the copy and you have no backups?

You...

In keeping with the humor........

The answer should have been Log Reader, the question was about performing last "WRITES" - not "RITES". Two different things.

-SQLBill

Are you sure it's location wasn't on ANOTHER drive?

-SQLBill

You can't do log shipping if you are attaching databases.

How big is your log file?

If you aren't doing backups (FULL and Log), then your database must be growing huge from...

I'm not a geocacher, yet. I've looked into trying it, but haven't had the time. I'm in Maryland, USA. There's quite a few sites near me, so hopefully,...

Could be:

1. antivurus checking the destination file when the backup job starts

2. antispyware running

3. another backup job backing up that file. Are your sysadmins/network admins running a backup job...

Why not just use CONVERT and MONEY?

DECLARE @test-2 VARCHAR(13)

SET @test-2 = '12345678.0000'

SELECT CONVERT(MONEY, @test-2, 1)

-SQLBill