It sooooo depends on what you're doing.

SQL Azure is different than SQL Server. However they offer some better backups/replicas in ways. No idea about pricing. I spoke with a few...

30. Backup is licensed by the server.

For the Virtual Restore side, if you wanted to run this on one server, one license.

Red Gate Sales do negotiate, so if you're interested,...

No hurry. We're 4-6 weeks out on publishing now.

Enterprise Manager should show the status of the database in the tree view. Does it look like all others or is the icon different?

I don't have a 2000 instance handy...

SQLRNNR (5/21/2012)

---

The pizza was not so good - but hey.

I had too much info to cover in 1hr15. I will be trimming it back somewhere. I have some...

Is that database in recovering or restoring mode?

HowardW (5/21/2012)

---

Restores can't be as fast by definition, as you don't have a backwards path to a point in time restore (Oracle has Flashback, a kind of reverse transaction log),...

SSMS works against Azure databases, so you can use that.

As far as migration, you connect with TDS and then move the data. Red Gate's Data Compare will work, as...

I'm not sure that you can count on the diff to be the size of data change. I suspect that changed extents in there are included, but if anything changes...

No. you're looking for some type of delayed resolution or a scalar replacement at run time, but that's not allowed.

You can't do a

declare @c varchar

select @c = 'Sales'

select * from...

That is old, and it's not something you normally do. I'd agree with Michael's advice.

Can you check the recovery model and post the exact code being used?

Jeff Kelly-310227 (5/21/2012)

---

it's exactly as Gila mentions.

I'm currently testing this with IBM's svc flashcopy manager.

These types of specialized SAN apps are fully SQL aware and use VDI (same as Microsoft's...

I assume you have queries to get this data? If not, you'll need someone to help you write a query. If you have questions on that, post some DDL and...

Sorry for the delay: http://www.rmtechtrifecta.com/

How can you apply transaction logs to a running database? Forget about the snapshot, how can you apply a transaction log to a database that is running without ever doing...