No, any 3rd party backup software will require you to be able to install something on windows itself. If that's not something you have access to, then you're stuck...

Yeah, you'll have to install sql mgmt tools somewhere and connect to that box under an admin acct. Once connected, you should be able to right-click on the sql...

I'm not entirely sure what you just asked me, but bol can be a little thick and what you want isn't always outlined exactly where you'd expect to find it....

Understand that with log shipping you'll have to kick everyone out of the DB to apply the logs, which is fine if you're only going to ship them once a...

The only supported way is to breakdown repl, setup dist on the new box, and then re-create all your publ and subs.

There might be a way through backup/restore...

You need to change your expectations here. Yeah, it would be nice to be able to have it all, but you're going to have to make a sacrifice somewhere...

I don't think you're going to have much luck. Not many people have bothered putting a lot of work into doing vids on erwin at all, much less anything...

In short, it can do almost anything you want. There are lots of videos and webcasts on their website so go check them out. It's really good stuff.

You do know that this is a SQL Server forum, right?

You may have better luck on the vendor forums.

I would like a little more info first.

Can you tell me what the different elements are? What's mdb, and what are the exact DBs and tables and schemas involved?

Have you looked into partitioning, or at your indexing strategy? I know SQL doesn't do parallelism when crossing partitions, but if you do them right, you shouldn't have to...

If you have a text field, your table won't decrease no matter what you do. The easiest way to get a nice, tight table is to just copy it...

OK, first off, there's no such thing as a huge access DB... but...

I would use the SSIS import wizard. It will connect directly to access and you can pull...

Then let me give you some advice... maint plans are worthless. Don't even go down that road. You'll spend more time tshooting them than you will anything else.

If...

y, sure...

init - will overwrite an existing backup file.

noinit - will append to the existing backup file, so you can have multiple backups inside a single file.

format/noformat -- these are...