Or - Intersystems Cache on a VMS cluster. 🙂

>2- Share multiple related DBs load...

NJ-DBA (2/2/2011)

---

No- it was never local system. It was first a domain account with the correct rights to dynamically create SPNs, then another domain account which did not have...

atsql (2/2/2011)

---

I launched DB shrinking which runs already more then 20 hours.

DB should get free space of 35 GB. Current DB size is ~80 GB. Free disk space is 129...

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...