Viewing 15 posts - 61 through 75 (of 322 total)
Does it not seem strange that the tempdb and a few smaller databases could not find their logs, but waited patiently until the link was back?
That's what has thrown me...
June 8, 2011 at 3:46 pm
m_cg (6/7/2011)
Another thought may be that you check the server properties.1. Under general, what is the root directory?
The D:\ folder
2. Under security, what are the login auditing and options?
None.
3....
June 8, 2011 at 9:08 am
Discovered something else of interest. 5 databases that are smaller (sub 1gb) all kept the logs on the virtual drive until it had returned. It was only the big databases...
June 7, 2011 at 2:52 pm
Yeah true. I have a tendency to judge things on my real life experience and I've had system admin's rave about their latest SAN and "no need to split log...
June 6, 2011 at 2:16 pm
To calvo - the data isn't an issue as we don't point in time report and the users were out of the system (it was a planned outage that encountered...
June 6, 2011 at 1:56 pm
Spot on.
Now tell me where I've mucked up? haha
June 6, 2011 at 10:01 am
The way I understood it was that to get the best performance for SQL out of a SAN you would want to split Data and Logs on separate groups of...
June 6, 2011 at 9:56 am
Well the people doing the reboots wouldn't even know how to do a SELECT statement so the chance of them attaching or creating a db is zero.
The database logs were...
June 6, 2011 at 9:49 am
Yeah I must admit I was surprised.
The chain of errors reads -
- Device activation error. The physical file name 'E:\Program Files\MSSQL\Logs\reporting_log.LDF' may be incorrect.
- Attempting to rebuild primary log file...
June 6, 2011 at 8:57 am
Will the db just stay offline if the default location is not available? or will it increase chances of corruption somehow? (database is backed up the the eyeballs anyway)
It will...
June 6, 2011 at 7:34 am
No problem.
My advice now would be - load the sheets into holding table first and then work out which records you are replacing so you don't end up with missing...
May 27, 2011 at 7:25 am
Whats the impact on business reporting of the order date being out 1 day? Some monthly reports would show up orders that shouldn't be there and should be in previous...
May 27, 2011 at 5:30 am
Just realised my method is no good as you can't work out which ones were wrong in the first place without reloading your sheets!
Will get back to you.
May 27, 2011 at 5:28 am
Seems to have rounded them all up by 1 day due to the time on the end? (some are probably ok though?) (confirm this)
If so it may be safer to...
May 27, 2011 at 4:56 am
Can you provide an example to work with?
i.e.
a) Value in Excel format
b) Date value you expected
c) Incorrect Date value currently in SQL
May 27, 2011 at 4:22 am
Viewing 15 posts - 61 through 75 (of 322 total)