The answer really is 'it depends'. It depends upon what else is running at the time, how many CPU's you have, how much memory, what your IO subsystem is...

You can also just remove sysadmin rights to the BUILTIN\Administrators group (after making sure you have another sysadmin login available).

cjohn5552 (10/25/2010)

---

Thanks very much for the replies. At this point, I'm not concerned with the administrative decisions that affect transaction log growth (although I'd like to better understand those at...

You have a simple mistake in your test:

SELECT key1, key2 FROM #tmp

EXCEPT

SELECT key1, key2 FROM #tmp2

I didn't thoroughly go through your code, but if all you are trying to do...

Okay, the error you are getting is an access denied error:

2009-12-31 12:12:51 - ! [241] Startup error: Unable to initialize error reporting system (reason: 5)

2009-12-31 12:12:52 - ? [098] SQLServerAgent...

No, I don't think a full backup will be any smaller because of backing up the...

To find the actual error for a maintenance plan, you need to look at the history on the maintenance plan instead of looking at the history of the job.

Right-click on...

I believe once you apply SP3 then you will be able to setup and use maintenance plans. It is also available in SP2, but there were a lot of...

Are you restoring the database to an instance of SQL Server on 'ServerB'? Or, are you trying to locate the database on ServerB and have it available from the...

What error are you getting that is preventing sql server from starting?

How did you change the account that SQL Server uses? If you used the services applet, then the required permissions were not assigned.

You need to use SQL Server Configuration...

You need to define what the last 10 is. A table is an unordered set - so, to get a particular order you need to use ORDER BY on...

No, you don't have to shrink. You want to shrink because that...

You are still trying to access nodes specifically - instead of using the virtual address for the resource you are accessing.

Which cluster group hosts the R:\ drive?

Let's say that your...

You best option is to restore from backups and apply all transaction logs up to the point of failure.

You can try to attach the database and let it...