What's the max size required by your tran log through the day?

How often are the log backups?

That's RTM. You've got 2005 SP2 on the server and 2005 RTM on the client. I would suggest you run...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic611653-338-1.aspx

When you can, run a full checkDB with no_infomsgs, all_errormsgs and see if it gives any errors back.

What build/patch level for 2005?

Do you have page checksums on for that DB?

If...

Agreed. Where in the world are you...

Chris Morris (12/1/2008)

---

Gail, did you notice in your testing if there was significant benefit in using

Where not exists (Select 1

instead of Where not exists (Select *

in Query...

If you click help - about in management studio, it'll show you the version of the client tools. What version do you have for management studio?

What version and service pack?

As part of the create snapshot, you need to specify all data files, not just one of them

So, it'll be something like this

CREATE DATABASE AdventureWorks_snap042007 ON

(NAME = AdventureWorks_Data, FILENAME...

In this case (and I tested out in adventureworks) the exists is better because by using that you're telling SQL that it doesn't actually need to get the rows from...

No. When a database is restored it is restored to exactly the same state it was when it was backed up. Including size of files.

When you create a snapshot, you must specify all of the files. The error indicated that you haven't specified all of the files that the DB has (excluding the log)...

Roger Abram (12/1/2008)

---

Just don't know how long this situation has occurred from within the database. So I wouldn't know where to start in terms of looking for a period...

p.s. that's the person's forum level (affected by no of posts), not the person's user name.

Some of the DMVs require compat mode 90, some don't. I can never...