OK, an update - you were entirely correct, it was the -0.00 that was the problem. Just spent the last several hours tracking down each record's key information via its...

Welsh Corgi (5/20/2011)

---

I think that you have good questions.

I have listed some links that may give you some ideas and compliment the questions that you already have.

You may want to...

rohaandba (2/4/2011)

---

There is a SQL Server Instance-1....With a Database-1....haveing 6 tables

Among which 3 of the tables have to be shared by

Another SQL Server Instance-2.....with a Database-2

Can anyone help me...

JenMidnightDBA (10/6/2010)

---

Matt Cherwin (10/6/2010)

---

I'm not sure I can agree with this - the nature of the field is geeky. That is: the desire to dive into the technology and ferret...

JenMidnightDBA (10/6/2010)

---

Agreed! I got into the field largely because of the geek factor, too. The issue isn't that we need to change, but that the field needs to be more...

Here's what I'd do, but it's cumbersome - hopefully someone else can chime in with a better answer.

1) Disable the login: ALTER LOGIN <login> DISABLE

This will ensure the login...

What edition/version of SQL Server are you running?

It's worth noting that Standard Edition only supports synchronous mirroring; if you want asynch, you need Enterprise Edition. It's also worth noting that...

From the same machine you were running osql on? If so, that's odd,...

Chandu-212374 (11/16/2009)

---

I used the following command after logging into windows machine as local administrator.

osql -SstrMachineName -UstrLogin -PstrPwd -i addsys.sql -ooutput.txt

(strLogin is an account which has login rights to SQL Server...

Panchi (9/15/2009)

---

Thank You for your reply . Your solution shows fy_month_start =3/29/2009 and fy_month_end ='4/25/2009' but its supposed to be '3/27/2009' and fy_month_end ='4/23/2009' .

For 2010 the fiscal year starts...

bpowers (9/14/2009)

---

Ok. The weekly maintenance job executed last night without a hitch. However, due to the rebuild on the indexes the log file grew 4G. The VLF's grew from 4...

I'm not entirely certain what you mean when you say you researched the history, and the log file was 6.2 GB - do you mean that it's been generally around...

Well, so much for my first guess. 😉

With that out of the way, a few comments/questions:

1) Why are you routinely executing a DB shrink? In general, shrinking a database is...

What did you do for backups before setting up this maintenance plan?

I ask, because SQL Server will "decide" that your recovery model is simple until you take a backup. So...

Oof. Personally, I demand that SSMS be...