durai nagarajan (8/30/2012)

---

hope i remember u have space crunch issue for backup.

differential backup is to prevent data loss from the previous full bakup idealy good if it has been done...

andrew gothard (8/30/2012)

---

SQL Server backups of all types are an online operation. Having people working while they occur is no problem ta all. Are you taking log backups...

Makes perfect sense.

Thanks for the tip! 😉

Grant Fritchey (8/29/2012)

---

The one thing I see missing are log backups. You don't list those as the types of backups, but you have databases in FULL recovery. If you're not...

durai nagarajan (8/23/2012)

---

[quote-0but I'm not sure where to store this database. I'm also unsure of how to get my information from the servers that are outside of the trusted network...

Sorry but what I meant was that management would like a report that would give them information on...

Paul Clark-418949 (8/23/2012)

---

Hiya,

You say these are staging tables...

Couple of questions then:

1.) Do these tables get cleared down as part of the staging process?

2.) If the above is true how often...

clayman (8/22/2012)

---

Abu Dina (8/22/2012)

---

Good morning,

We have 5 SQL Servers used by operations team.

QBDB01 - 62 Databases

QBDB02 - 41 Databases

QBDB03 - 39 Databases

QBDB04 - 31 Databases

QBDB05 - 28 Databases

The databases...

durai nagarajan (8/22/2012)

---

Maintenance plans are built in SSIS packages and T-SQL are sql code.

both of them has to use jobs to execute at certain intervals or time.

it is your option...

durai nagarajan (8/22/2012)

---

what type of data available explain more clearly and what level of data loss is acceptable.

if the data...

The databases are merely staging DBs used to perform data cleaning/merging etc.. HD space is not suficient...

Thanks CSGuard. I will try and create a CLR implementation if time permits and will report back.

Thanks for the feedback GSquared.

I started off with a small list for my titles but then I added some more from a list of titles I found online 😀

Jeff, I know it's almost 5 years since you posted this solution but if it's any consolation then let me thank you for this code.

I'm learning so much from your...

Yup, I'm officially a SQL n00b! (http://www.urbandictionary.com/define.php?term=n00b)

Thanks Jeff, Cadavre & Chris.