What you mean if web server doesn't serve any other...

MyDoggieJessie (4/17/2013)

---

It Depends. If the app servers are going to be looking to the SQL Server for a connection you may want to put of a "sitedown" page to...

Thanks for your reply, do you know if the app server need to be shutdown as well?...

GilaMonster (4/8/2013)

---

SQLCrazyCertified (4/8/2013)

---

GilaMonster (4/8/2013)

---

Neither.

Overwrite would be rather silly with log backups since you need all log backups in...

Please ignore.....sent in error.

SueTons.

GilaMonster (4/8/2013)

---

Neither.

Overwrite would be rather silly with log backups since you need all log backups in sequence to...

Thanks guys.

SueTons.

SQLRNNR (4/4/2013)

---

SQLCrazyCertified (4/4/2013)

---

mp5387 (4/4/2013)

---

I am intermediate in database admin. Please give me your solution for this issue.

Size of my db is growing about 5M every 2 weeks....

mp5387 (4/4/2013)

---

I am intermediate in database admin. Please give me your solution for this issue.

Size of my db is growing about 5M every 2 weeks. Now its...

I didn't go through all your script however, you can shrink your log file using

Use database name

DBCC SHRINKFILE (logical name, 1024)

If it didn't work first time, try couple of...

Thanks guys. I found this article, see below.

This is actually doable, however the only issue is that, “The biggest issue is that maintenance plans have a hard-coded connection and...

So, you are saying that these plans won't...

fatinfzi (3/25/2013)

---

Hi,

I need help with my database. The database is mirror to another database and not the disk is full. No free space for transaction log. One of my colleague...

Lynn Pettis (3/22/2013)

---

The way I would start, is do the first one manually creating the scripts as I went along using SSMS. Then it is just a matter of...

I know this is doable by using sp_msforeachdb and a loop, but not really sure where to begin with.

SueTons.