What do you use as the...

rudy komacsar - Doctor "X" (8/5/2010)

---

Dependent on your DR scenario no scripting may be required.

Usually in a DR situation you will be loading/recovering user databases.

Why not just precede this with...

HowardW (8/2/2010)

---

You can find most of the information in the sys.servers view to build a script for this.

Otherwise you could use SMO to script this programatically.

If they are static,...

I found some additional information at http://searchsqlserver.techtarget.com/news/1102101/SQL-Server-password-policies-and-credentials, but I am not sure how to use it.

If I am reading correctly, SQL Server will use local policy setting for the maximum...

Wrong forum--sorry, I'll post in the 2008 forum

janki_2886 (6/1/2010)

---

i shrink a datafile using DBCC command ( That also had TruncateONLY Option) and I also Reorganize all the indexes then after.

But still i t doesn't releases unused...

Nice job on the documentation. Thanks for the link!

So far, I have only tested on one physical node, and I have made an SMK (Server Master Key), DMK (Database Master Key), and certificate backup on that node. How...

Laerte Poltronieri Junior-367636 (5/2/2010)

---

I did not think much on how to join the output of sqlcmd with powershell, but there is a possible solution made in powershell for everything (not...

Laerte Poltronieri Junior-367636 (5/2/2010)

---

I did not think much on how to join the output of sqlcmd with powershell, but there is a possible solution made in powershell for everything (not...

Here is the long version.

- All of our SQL Server backups go to disk and subsequently...

In addition to performing database backups, the...

>>http://www.codeproject.com/KB/database/ConfigureMSDE.aspx

Damon,

Thanks! This is a great link!

Actually, we tried that, but we got an error. Can you post some sample syntax?

Is there a way to set job ownership in a maintenance plan to a group, instead of a single account?