Viewing 15 posts - 42,721 through 42,735 (of 49,566 total)
What's the max size required by your tran log through the day?
How often are the log backups?
December 2, 2008 at 12:55 am
rnunez (12/1/2008)
Heres all the information from Help..aboutMicrosoft SQL Server Management Studio9.00.1399.00
That's RTM. You've got 2005 SP2 on the server and 2005 RTM on the client. I would suggest you run...
December 1, 2008 at 1:56 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic611653-338-1.aspx
December 1, 2008 at 1:49 pm
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...
December 1, 2008 at 1:41 pm
Steve Jones - Editor (12/1/2008)
I'd go look at what's offered by SQL Skills, Solid Quality mentors, Scalability Experts and see if something fits.
Agreed. Where in the world are you...
December 1, 2008 at 1:35 pm
Chris Morris (12/1/2008)
Where not exists (Select 1
instead of Where not exists (Select *
in Query...
December 1, 2008 at 1:19 pm
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?
December 1, 2008 at 1:03 pm
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...
December 1, 2008 at 9:33 am
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...
December 1, 2008 at 9:26 am
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
Viewing 15 posts - 42,721 through 42,735 (of 49,566 total)