NJ-DBA (2/2/2011)

---

I figured it out. Here is what happened:

The app folks changed the SQL Service account, but did so using "services.msc" not SQL configuration manager. I believe that...

The retention period is not used for file based backups. It was originally included to allow backups on devices (e.g. tape, optical, etc...) to be marked when the device...

Steve Jones - SSC Editor (2/1/2011)

---

What I don't know is can I setup all my internal monitoring on these servers and still call them passive? Or can I run dbcc's...

It looks to me like you are trying to round down to the hour for your date column. This is assuming that your column ctDate is a datetime column...

Just a guess, but I am thinking that you don't have instant initialization enabled and that is causing the time delay. Without that, SQL Server has to zero initialize...

Here is another way to structure the query using a common table expression:

;With OrderSet (DrugID, OrderSetID, OrderID)

As (

Select DrugID

...

I would recommend talking to your MS rep about this to make sure, but I think your passive node would not have to be licensed.

With that said, I probably would...

As everyone else has already stated - you shouldn't be shrinking the data file.

With that said, to answer your question - DBCC SHRINKFILE is working as expected. When you...

I don't have the link handy, but Brian Kelley has an article on this site about setting up and configuring Kerberos.

As to which SPN's you need to set up -...

bhargavgampala (1/26/2011)

---

Thank you so much .Your support is appreciated.

After checking disk usage report, we think that growing respectively 200 Mb for DATA file and 60 MB for LOG .

so...

I am glad you were able to solve the issue - and interesting that being in the administrators group changes the owner.

I would recommend that you change the owner of...

That sounds like a permissions issue to me - which would explain why files from the other node cannot be deleted.

A couple of things to check:

1) Are you backing up...

fnostro (1/24/2011)

---

Hey Jeffrey,

I know what you were getting at - the jibes were all good natured in intent, no worries.

if you read my last post I found the cause of...

Hey, wasn't trying to show off or anything - what I wanted to show was that you can get those backup times way down with the right configuration.

And, to be...

Here is another way to create your tally table:

--==== cteTally

With e1 (n)

As ( --=== Create Ten 1's

...