There are a few issues with snapshots.

they don't stay up to date. They are a point in time. To update it, you need to either drop the snapshot and recreate...

You can't selectively restore logs, but you can continue to restore filegroups (new FG backups) over time.

Just a note, and not to impact performance any more, but R0 is asking for trouble. One failure and everything is lost. You might have to reinitialize the subscribers and...

I assume you mean database and not table. A table uses the space allocated to it, +/- an extent. A database should always have reserved space. The table might...

That works if the logins are new. If there is an existing login, you would need to use sp_change_users_login. As to auto or one, it depends. Auto should fix all...

I'd agree with Seth. You don't need an identity, but you need a unique way to identify rows, otherwise you're likely have have similar issues in the future.

I sometimes think people are trying hard to build a reputation by answering, and don't want to read. They want to just throw something out there.

Thanks!

I'm not sure WMI is easier, or even more foolproof. We had issues in W2K with the service. Not sure about W2K3 or @2k8

However, I agree that posting the...

IAN has stated it well, but I tend to like combining apps on one server. Hate instances because of the memory issues, but I do like sharing stuff.

I'd dig in...

Attila (8/14/2009)

---

My question is:

-Can I have a SQL2000 and SQL2008 default instances (with different ports, of course) in the same time on a box?

-What are the drawbacks of using SQL2008...

I don't think you can mentor yourself, but what I would do is contact people, ask questions, see if you bond with someone and can build a relationship. You might...

I'm kind of with Adam here.

I might go with mirroring, perhaps using an asynchronous mirror so you don't interrupt production if you have issues with the link. However I'd also...

I'd look at SSIS. If you put the tasks on designer without precendence constraints, they'll run in parallel.

They are used for different purposes. both copy data at periodic intervals, but they work differently.

snapshot - copy all the data at the interval as one batch. It's essentially an...