John Mitchell-245523 (10/2/2014)

---

Nice one. You could also query one of the system views, for example sys.master_files, to build your list of databases at runtime. That way, you know...

Hope this help someone. This is how I approached and fixed this problem:

--Declare variable that will contain set with databases over 100GB

DECLARE @DBList VARCHAR(MAX)

--Set and loop to grab db values

SELECT...

cygne17_2 77208 (9/24/2014)

---

hi,

thanks for your answer.

Can I use a domain account for the mirroring purpose only and stay with SQL Server Service run with NT Service\mssqlserver ?

Which privilege do I...

adrian.buzila (9/24/2014)

---

My DBA (I'm developer) did not agree with the flag, said it will impact performance, sql2008 identity is more resource intensive.

I implemented you first solution with reseed max value....

cygne17_2 77208 (9/24/2014)

---

Hi,

I am trying to configure database mirroring with sql server 2012.

My principal instance and my mirror instance are on different server.

Both SQL Server service run with NT SERVICE\MSSQLSERVER.

Now...

Yeah, my bad, forgot to post the query that lists the names of databases bigger than 100GB.

But I think I got an idea of how to do it without altering...

bump!

anyone?

Johnny B (9/23/2014)

---

SQL 2012 Standard on Windows Server 2012 Standard

After observing brute force attacks on our VPS myhosting instance against the SA login, I change the SA login name....

Wow! One of those...

fyi

On some cases, you may find that it is better to...

DBA From The Cold (9/23/2014)

---

The guys here and over at Stack Exchange have got it right (IMHO).

I inherited a 3TB database with thousands of VLFs (in three .ldf files on...

I've had good results with robocopy, which is included on Windows. It is really fast. It is smart enough to retry, and I can control what to copy depending of...

Take a look on this article that Kimberly wrote: Transaction Log VLFs – too many or too few?

Attached the script I used. Please test 1st, on Dev environment. Adjust upper...

Yes, VLFs count. Fix them. They can get out of control due improper auto-grow settings for your Tlog file. If you have thousands of them, it will take longer for...

loading 1.5 million records into a temp table should not be the question to ask. The main thing is, do you really need the whole set there? With a properly...