Restricted user - only users with dbo rights on database allowed

single user - only one connection allowed, first come, first served

The closest to what you seem to be asking for is the log backup, in that a restore of a log backup will restore changes made since whatever backup you...

I'll re-phrase the above I think, certs are evidence you can use to show you have put effort into your career

not this old chestnut again!

Of itself certification does not prove anything, but at least it shows some effort has been put in on your career, and HR and management tend...

before restoring a differential backup you must first restore a full backup with the norecovery option.

This is the only way to do it.

note: differential backups are cumulative, so if you...

look forward to it dave.

congratulations 🙂

Even if you have changed the recovery mode of master to FULL, it will still be operating in simple mode. Master ignores recovery mode changes.

think about it, to restore a...

there is the waittype column in sysprocesses or the dmv sys.dm_os_wait_stats

Our OS drive would be a local mirrored drive, the database drive either local or SAN raid 5. Important thing though is only one io controller each, so its 2...

Just to note that using a GUID as a primary key might not be a good idea if the index is created as a clustered index due to the random...

You have 6Gb worth of data, max 18 concurrent connections and 16GB memory. sounds like you will be accessing data more from memory than disk. I would raid the disks,...

you haven't said if you have updated your stats at least?

If you have moved a db from a sql2000 instance to a sql2008 instance on the same server the overall...

Neil, I think the important thing here is you get jobs set up to backup your database (full and log backups).

🙂

some good points Tim, and perhaps a timely reminder for anyone suffering from 'forum fatigue'.

there will of course always be people who cannot accept having their points clarified, let alone...