Ok, please answer every question as fully as possible;

1) why are you log-shipping at all? What are you hoping it will achieve for you (or is this purely experimental for...

You're not looking at heaps, are you? Those won't be affected.

I don't really understand your backup strategy. Why are you only backing up the log once a day? Did you switch recovery model to Full purely because you wanted to...

So you're only taking one log backup a day right before your full backup? Then that "error message" you're getting makes sense, no?

Bit late to this, but congratulations! How's it going- have you started yet?

How long have you been in the role? Maybe they're trying to get you used to their environment for a few months?

Beatrix Kiddo (6/13/2014)

---

Ok, then something else may well be backing up your database and breaking your log chain (as far as log-shipping is concerned). I'd check that with your sysadmins.

It...

happycat59 (6/19/2014)

---

fkarmally (6/19/2014)

---

I copied my mdf and ldf file to the cloud server, and the data path is correct. But the database does not show up in management studio. I...

It's loads easier if you use TSQL as described above.

Hi, yes it's that easy, and yes you should definitely schedule log backups. First take a full backup though, as otherwise your database will be operating in what is known...

I very much doubt that though.

GilaMonster (6/17/2014)

---

Andrew Kernodle (6/17/2014)

---

Simple! No job I've ever held so far has allowed me...

Do you mean you created a named instance? That's fine.

As part of our post-install checklist where I work we specify the size, autogrowth settings and recovery model of the Model database according to what generally works for us.

Andrew, how do you cope with no annual leave? (If that's not too personal.)