Welcome to the club :hehe:

Is this a level 90 database ?

- We create the backup file on the production server.

- Copy that file to safezone. (next step of the backup job)

This is scheduled at 19:30

On some of our dev...

SKYBVI (9/8/2010)

---

I RAN:--

RESTORE DATABASE XYZ

FROM DISK = 'E:\xyz_backup_201009022015.bak'

WITH MOVE 'logical_name.mdf' TO 'E:\SQLDatabases\XYZ.mdf',

MOVE 'logical_name.ldf' TO 'E:\SQLLogs\XYZ.ldf',

STATS=5

I recevied error:-

Msg 64, Level 20, State 0, Line 0

A transport-level error has occurred when receiving...

Hurry up 😀

must be a photofinish :hehe:

Hi Steve , I hope you're not on the run for the forrest fire issues near Denver.

Thanks. Just making sure I didn't misinterprete it.

So, Ioana there is still a aftermath to do after the db got back online.

The provided urls should get you on track.

Simplefied steps:

--...

Did you try your restore using the "restart" parameter ?

I've had a similar issue with a bak file >99Gb.

If I'm correct, it was related to some W2003 32bit bug...

Hi Gail, Sorry for hopping in but would this be a typical case of VLF fragmentation ?

ref: Monitoring SQL Server Virtual Log File Fragmentation

http://www.simple-talk.com/sql/database-administration/monitoring-sql-server-virtual-log-file-fragmentation/

Performance impact: a large number of...

- what kind of size are we talking about (current , target) ?

- how long did you wait for it to complete ?

- check (b)locking when you run dbcc shrinkfile...

You mean in the DDL of these objects ?

check database triggers !

e.g. http://www.sqlservercentral.com/scripts/DDL+Triggers/64536/

If it's a huge database you can add the "restart" parameter to your (original) restore statement, and it will pick it up where it got killed.

Make it "foolproof" and they'll come up with a better fool 😀

Thumbs up for the new job ...

Damon Falconi-345992 (9/1/2010)

---

There is a fix - Cumulative Update package 3 for SQL Server 2008 R2 -

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

I applied this and it resolved the issue... If you wade through the...

Thank you for sharing your findings and observations.