noeld (3/16/2009)

---

Steve, the UI lets you fix it. Totally agree with you, for small DBs it is easier to redo than repair.

The Problem that replication really impose is "planning"....

Noel -

Thanks. I can verify. The issue is fixing if it's wrong. In general, as a 'newbie' I find it easier to stop existing replication and start...

1. I inherited this beast, so documentation was sparse at best. I fill in as I go, but I still miss items.

2. It is production, so I...

Roy, to answer your question: 10%, with a restriction of 2,097,152 MB. Since the database is not housed on a 2+ TB drive, that limit is meaningless, yes?

For...

SQL Noob (3/13/2009)

---

i've done bulk inserts which is the same way a snapshot replication does it and the log file can grow even if it's simple recovery model. i think...

Good point! When I restored the database over from the production server, restoring from a backup of the production database, I failed to change from full to simple. ...

One thought that might work -

Did you check the replication jobs that you have running? In theory, if you go in and disable the jobs (uncheck the 'enabled' box),...

Chris,

Good to know for the future. But, I believe that EM was telling me true, because after I followed the full flow of backup, transport, restore, thoroughly, I found...

GilaMonster (2/25/2009)

---

The true cautionary tale arising out of this thread is that database snapshots, when scheduled regularly, may or may not capture all changes in a database, depending on what...

Sorry all. This is the first time that I've experimented with using font sizing. Does '2' work better? [pls reply only if you need larger]

Gail -

yes,...

All,

Thank you for the responses and suggestions. When I checked the restore this morning, the database was properly synchronized and all the views appeared as expected. (The directory...

Jeff,

Well, that will explain why the reports server doesn't have the new views (doesn't need them, anyway). I'll have to wait and see whether tonight's backup brings over the...

Well, let's see... I take a backup. I zip the file before copying it across from one server box to another server box. Then I unzip the file...

Actually, it's a bit messier than I described. There's the production database, the DR database, and a 'man in the middle' - a reporting instance used to take some...

This may sound like a weird question, but why didn't you simply take a full backup of the database, zip up the backup, and ship the (encrypted) zipped file with...