It seems there are any number of tools to replicate data from ADABAS to relational databases. If you need a cross platform tool, I'd suggest you start evaluating the various...

Congrats, Jack. Hope to see you soon and shake your hand.

Matthew Joughin (9/29/2011)

---

I would say the way pioneered by http://www.StackOverflow.com is the best way, where responses are voted for, but you can only vote for a response if you have...

Software assurance has no effect on your install. It's strictly an administrative item, not a technical one. Meaning the install doesn't know if software assurance was purchased.

The only decent week I've had. Big Ben and Shawn Greene are killing me.

You can close some connections and those objects will drop their tempdb space. Or cancel the transactions.

You could try adding 5MB to the existing file and then grow on...

Clustering works with shared storage. When the passive node picks up, it picks up the storage that was being used by the active node. Some SAN technologies or geo-clusters play...

Yes, here's some powershell code that does that and runs a backup of there's an alert. however the comments describe essentially what you're doing: http://www.simple-talk.com/sql/backup-and-recovery/alert-based-transaction-log-backups---automate-your-database-maintenance-part-2/

Brandie Tarvin (9/28/2011)

---

Do not tempt me. I have done things like this before. @=)

Speaking of writing, follow this link if you like high fantasy and want to read a story...

Once the iSCSI disks are attached, the procedures for both of these are available in books online or on the web. I would suggest searching for them.

You'll need to grow tempdb to gain a little space for the growth operation.

You can restart SQL Server as well to clear the tempdb db and recreate it.

Easiest way is to backup and restore as a new database (new name), delete the data in each database you don't need.

If you do this regularly, you need to build...

Brandie Tarvin (9/28/2011)

---

SQL Kiwi (9/28/2011)

---

WayneS (9/27/2011)

---

• DBA Certification preferred in SQL Server versions 2000, 2005, and 2008.

• ...

Do you mean "can I" technically, in that will it work? Or "can I" license-wise?

The former is yes: http://msdn.microsoft.com/en-us/library/ms143393%28v=SQL.100%29.aspx

The latter is no, not without a cost. Even with software assurance,...

It would depend on the deletes. The extents could be reused, and dropped out on deletes, but if you deleted a page or two out of each extent, I'm not...