I've never had a problem backing up or restoring via UNC path in SQL. I don't do it a lot, it's not ideal, and it's slow, but it does...

Thanks for the replies. I think there are some hiccups on our VPN that's causing the problems. I heard a couple of others here are having the same problem, along...

Sounds like you're referring to logical devices, not a separate machine that has tapes.

I prefer to keep all the databases separate. I don't use backup devices. I backup each database...

These are just little personal utility scripts I have on my network share drive ..... Nothing else would use them or even know about them.

homebrew01 (9/8/2008)

---

Good Luck !

There are other IT tools outside of SQL, used for pushing NON-SQL data to different locations, that use the word "replication" in their name or description. Perhaps...

How big are the tables ?? If they're huge, transactional replication might be good. otherwise the SSIS option would be simpler.

Good Luck !

There are other IT tools outside of SQL, used for pushing data to different locations, that use the word "replication" in their name or description. Perhaps some people...

If you have ongoing needs to keep location 2 updated with data from location 1, day after day, week after week, then replication is the way to go. If you...

Or maybe you have SSMS Express on your desktop.

ALZDBA (9/8/2008)

---

There is no move of the datafiles at alter database time !

With Tempdb, your need the alter database to update the catalog

and you'll need the stop/start to create...

Even though you ran it in master, not your own database, you still should...

Bob Fazio (11/27/2007)

---

There are no good techniques for preliminary sizing of the tempdb. This is because it's usage has almost no correlation with anything else.

The short answer...

Vika (9/4/2008)

---

Guess what I am doing now? Making SQL Agent jobs to back up all the databases on the production server. I run that useful query that some nice person...

Rod at work (9/2/2008)

---

In a previous post I asked about replication between and old production server and a new production server. We're going to go ahead with replication between...

I used SQLSafe by Idera ... sounds similar to RedGate's. The other ideas post above are also good options.