If you design it well, it may.

That's why you should especially take care of your indexes to be alligned.

This is one of the reasons why you must first read about...

classic answer : It depends.

In some cases partitioning may be a great solution (ent edtn only)

The problem will always be : how does sqlserver detect "date range" to filter its...

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 ...