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

Grant Fritchey (6/17/2011)

---

george sibbald (6/17/2011)

---

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

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?

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

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

quick straw poll if you don't mind guys -

how much access should developers have in a development environment?

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

try the cluster log or the system log in eventvwr

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

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? 🙂

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.

come on you lot, don't be mean, tell Rich about the special 'perks' we get.

if looking at these through SSMS have you refreshed?

run sp_helpuser in the database to check current situation

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

+1