Jeff Moden (9/12/2016)

---

sjimmo (9/12/2016)

---

Jeff Moden (9/12/2016)

---

BI_NewBie (12/3/2014)

---

Hey Jeff!!

Thanks for your reply.

In my database, there is a transaction table whose row count is 117690142. There are index created on column but...

TheSQLGuru (9/12/2016)

---

Sounds like you know what you are doing Steve. Kudos for you! Do note that we don't get a whole lot of that on these forums (because if they...

Jeff Moden (9/12/2016)

---

BI_NewBie (12/3/2014)

---

Hey Jeff!!

Thanks for your reply.

In my database, there is a transaction table whose row count is 117690142. There are index created on column but still when we...

Is this any help? It's for SQL 2012.

https://social.msdn.microsoft.com/Forums/en-US/098fb5b0-d3ad-4008-b7c5-8d810b89f4f7/sql-server-2012-frequent-system-health-monitor-thread-operating-system-error-exception-0x1?forum=sqldatabaseengine

Error log entries on the screenshot:

System Health Monitor Thread: Operating system error Exception 0x1 encountered.

Error: 17053. Severity 16, State:1

External dump...

You need to identify why you are receiving the stack dumps.

What version of SQL Server is this?

If you just move the tables, but not the data, what's the point. You could simply script the database. If you move the tables, but not the foreign keys, constraints...

In order to do this you would have to have your tables on separate file groups (Not on PRIMARY) and perform backups of each file group. You could then restore...

Thanks Jeff. I was simply offering an alternative. Should have looked more closely at the dates. :hehe:

DECLARE @valVARCHAR(30)

SELECT @val = '9.0.0832.1032'

SELECT @val

SELECT SUBSTRING(@val, LEN(@val) - 6, 2)

This was...

Steve Jones - SSC Editor (6/14/2016)

---

Does the password have to be NULL? Or can it be blank? Can you set the SQLCMDPASSWORD environment variable?

The docs definitely support that this should...

That's interesting, as that is contrary to what MS says about encryption (not specifically backup). So the assumption is there. Learn something daily 😉

One note though, the expiration is ignored if the cert is used for encryption

My question is are all of the files making up the database on one file/filegroup?

Ideally I would, for a database this size, perform all of the dumps using file/filegroup. It...

The impact will be on the distributor, and how long you have set the history for.

The publishing database performs some data manipulation. These are sent to the distributor and held...