Viewing 15 posts - 1,711 through 1,725 (of 4,745 total)
[quote-0Part of my requirement for dev is that it be set up in such a way that breaking it inconveniences nobody except the devs. [/quote-0]
How do you do that...
June 17, 2011 at 7:54 am
Grant Fritchey (6/17/2011)
george sibbald (6/17/2011)
Gus, SA in dev, really? Should that ever be a necessity?
any...
June 17, 2011 at 7:50 am
cheers guys, not too far off my views, though I am not sure about security admin.
Gus, SA in dev, really? Should that ever be a necessity?
any more for any more?
June 17, 2011 at 7:28 am
note, there is no point in having multiple log files, SQL only writes to one at a time so there is no performance gain in multiple log files.
As for how...
June 17, 2011 at 7:18 am
the structure of the database is held in the backup. So the new file structure will be created on the next restore as long as the directory layout you are...
June 17, 2011 at 7:05 am
quick straw poll if you don't mind guys -
how much access should developers have in a development environment?
June 17, 2011 at 6:43 am
Scott, you say the VMs performed better even with much reduced CPU and RAM allocated. How old were the physical servers replaced?
Was one of the drivers for this a server...
June 16, 2011 at 6:58 am
try the cluster log or the system log in eventvwr
June 15, 2011 at 3:54 pm
To avoid this problem in the future, next time your instance is down take a flat file copy of the system database files to another directory (including the resource database)....
June 15, 2011 at 9:29 am
there is a logshipping alert which will warn you if the secondary is out of synch by more than a set amount.
2 secs before or 2 secs after? 🙂
June 15, 2011 at 7:30 am
last log restored information should be good enough, but you could add your own table to the primary, update on a regular interval and check the value in the secondary.
June 15, 2011 at 7:20 am
come on you lot, don't be mean, tell Rich about the special 'perks' we get.
June 15, 2011 at 7:14 am
if looking at these through SSMS have you refreshed?
run sp_helpuser in the database to check current situation
June 15, 2011 at 6:52 am
Having now restored a backup of the model database at the correct version I would now restart SQL again just to be sure.
Did you not get the model db files...
June 14, 2011 at 10:22 am
GilaMonster (6/9/2011)
If you get Diskeeper, patch it to the latest version immediately. Some of the older versions have nasty corruption- or error-causing bugs
+1
June 14, 2011 at 6:51 am
Viewing 15 posts - 1,711 through 1,725 (of 4,745 total)