Viewing 15 posts - 42,736 through 42,750 (of 49,571 total)
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.
December 1, 2008 at 9:15 am
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)...
December 1, 2008 at 9:15 am
Roger Abram (12/1/2008)
December 1, 2008 at 9:08 am
daniel.cloutier (12/1/2008)
Thank you Gail and SSCarpal Tunnel,
p.s. that's the person's forum level (affected by no of posts), not the person's user name.
December 1, 2008 at 9:06 am
Lynn Pettis (12/1/2008)
Good catch Gail. I didn't think of asking what compatibility mode the database was using.
Some of the DMVs require compat mode 90, some don't. I can never...
December 1, 2008 at 9:03 am
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...
December 1, 2008 at 9:03 am
That's no a serious problem.
As the output from CheckDB said:
Run DBCC UPDATEUSAGE.
No real backups.
Why not?
December 1, 2008 at 8:48 am
If I could send a print screen I would but it is not in any of our servers right noew
It's included in all editions of SQL 2005, from enterprise right...
December 1, 2008 at 8:39 am
torpkev (12/1/2008)
Reorganize data and index pages (change free space per page percentage to 10%)
There's your culprit. Index rebuilds are fully logged and have nasty effects on a tran log.
You can...
December 1, 2008 at 7:25 am
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,...
December 1, 2008 at 7:16 am
Are you sure your windows login is a member of the sysadmin group?
December 1, 2008 at 7:11 am
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...
December 1, 2008 at 7:10 am
All of the DMVs are present in all editions of SQL 2005.
What error are you getting?
December 1, 2008 at 7:07 am
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...
December 1, 2008 at 7:04 am
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...
December 1, 2008 at 6:56 am
Viewing 15 posts - 42,736 through 42,750 (of 49,571 total)