Is it a backup job from a maintenance plan or script? Can you provide the script you are trying to execute?

rmatthias001 (12/1/2010)

---

If I wanted to set up a test environment at work on a machine seperate from the production servers that would be used to run tests on replicated...

YSLGuru (11/30/2010)

---

The restart is not my decission, IT makes those calls. That said I'm suprised to hear this level of "No reboots " comemnts. The system...

Translated

Hi all, I would help a lot if someone could answer if there is no way to create a backup of a database using the BACKUP statement in Transact-SQL which...

YSLGuru (11/30/2010)

---

I’m looking only because I’d like to see if there are alternatives because I’ve had some issues recently with these scheduled tasks running reliably and so my DB Servers...

I'm not sure what level of MSDN subscription you have but there are 32 and 64-bit versions of SQL Server 2008 R2 available for download. I show it as "SQL...

In my environment they are, and it also puts less stress on the server since C2 auditing captures everything going...

GilaMonster (11/26/2010)

---

Shawn Melton (11/26/2010)

---

This script from the checklist will actually create a stored procedure that will run at the time SQL Server starts up. You just past this into a...

You will actually want to go download the current version of the checklist. (I'm a contractor with military).

This script from the checklist will actually create a stored procedure that...

You might be referring to this link How to: Upgrade to SQL Server 2008 (Setup)?

I believe they are referring to registering your servers within SSMS:

New or Edit Server Registration...

IMHO: You can never have to many backups when you do major maintenance on your database. As long as you know those backups are tested and ready to restore from.

Developer Edition should work on any Edition of Windows XP SP2 or higher. You might take a look at the installation log to see if any errors stand out (refer:...

I can't actually view your attachment (not on good computer with Word 2007), can you elaborate on what error you are recieving?

What Edition of Windows XP and SQL Server 2005...

I'd like to take a stab at this one

All I know of PowerShell right now is the basics 😀

BigSam (10/28/2010)

---

Thanks, I understand better now. Can you explain what happens in a 2-node cluster that is active/active? Does each instance 'mark' a database as active on that server &...