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

Just bear in mind that there is a subtle difference in behaviour between the coalesce method and the Varible IS NULL OR Variable = Column method. Specifically when the...

That's no a serious problem.

As the output from CheckDB said:

Why not?

It's included in all editions of SQL 2005, from enterprise right...

There's your culprit. Index rebuilds are fully logged and have nasty effects on a tran log.

You can...

CheckDB, when run without options, just checks for errors.

The best options for checkdb (when run as a regular integrity check) is with the ALL_ERRORMSGS and NO_INFOMSGS options.

If you get corruption,...

Are you sure your windows login is a member of the sysadmin group?

Please post in the appropriate forum.

In my opinion, the 'repair minor errors' option should not be checked. Minor corruptions may indicate larger problems in the future. If they get repaired...

All of the DMVs are present in all editions of SQL 2005.

What error are you getting?

Ow! Multi-statement table-valued functions are an absolute pain and they tend to perform very badly with larger rowsets.

How many rows do those return?

This update is not necessary. You should be...

SQL won't release memory by itself. That's by designs and it's expected behaviour. It will only release memory when the OS requests it (in cases of low memory) or when...