Excellent.

Apparently option 1 is the option of choice. My only worry was that if you were in production, it might stop stuff in the middle of processing.

Does that help?

IncidentalProgrammer (1/6/2015)

---

Grant Fritchey (1/6/2015)

---

Nah, the basics of backup are, well, basic. You'll be fine. Restore gets marginally more complicated. But then it can get crazy as you start to add...

Jason,

Is this production or a non-prod environment?

Quick technical question (don't hurt me!). Google Fu refuses to tell me the max size of an object variable in SSIS 2008. Anyone know this off the top of their...

Jeff Moden (1/13/2015)

---

I...

Brandie Tarvin (1/13/2015)

---

That is just the General tab, and not even all the information on it (timeout, codepage, bypassPrepare). What about the other three tabs, Parameter Mapping, Result Set, and...

That is just the General tab, and not even all the information on it (timeout, codepage, bypassPrepare). What about the other three tabs, Parameter Mapping, Result Set, and Expressions?

Side Note...

jasona.work (1/12/2015)

---

I'm working on cleaning up some bad choices made during SQL setup on a few boxes of mine, and one of the items on the list is getting the...

SAMDEV (1/13/2015)

---

Hello Erin

I would like to use same technique while inserting records into existing table. Is it possible by any way?

As per my knowledge IDENTITY function can be used...

Benki Chendu (1/12/2015)

---

I see some 12 tables being modified between the full backup and the differential backup taken in the next 5-6 hours but none of them seem to be...

You've posted this in the wrong forum. I'll ask Steve to move this to the 2012 forum.

Without knowing a few more details, this one is hard to answer.

Can you post pics of all tabs on your EXECUTE SQL task?

Also, how many is "more records"? Have...

SQLisAwE5OmE (1/13/2015)

---

GilaMonster (1/13/2015)

---

Script all their modified procs, views, functions out. Backup, restore with overwrite. Run script with all objects (take a backup of their DB first, just in case)

Likely to...

Peter2012 (1/12/2015)

---

Hi Gurus,

We're using SQL server 2008 R2 and have been receiving the following error messages recently.

----------------------------------------------------------------------------------

Error: 14421, Severity: 16, State: 1.

Date12/1/2015 12:06:00 PM

LogSQL Server (Current - 12/1/2015 5:45:00 PM)

Sourcespid55

Message

Error:...