Enter the full unc path for the remote location in the path section of the GUI. I.e.

\\RemoteServerName\ShareLocation\BackupFileName.bak

If the permissions are setup correctly, then SQL Server should be able to restore...

Have you upgraded from 2008 to 2012 on the same server? If so, potentially, you may be running 2008 Configuration Manager and this wont pick up the 2012 instance....

Interesting. I dont know the answer, but it could be to do with having the values set in the variables, as being explicit with the decimals and cast gives...

homalves (10/17/2014)

---

I made a mistake in my first post that can give the idea that I'm against autogrow. That's not the case. While I'm not a big fan, what I'm...

Autogrowth allows for a safety net, but it is also good to set up alerts to raise an alarm when the log grows over a threshold. This would mean...

I ran into this issue when applying the sp2 to our dev and UAT servers. I took note of the process number and killed the service via task manager....

You're right, the log should shrink. Are you sure the log backups have been successfully restore to the secondary database? What information is in the [<secondary_Server>].msdb.dbo.log_shipping_monitor_history_detail table about...

I would speak to Microsoft licensing to check, but my view would be you would need the same number of cal licenses or an appropriate server license for the 2012...

I don't know why it would not be possible. The VM's will be acting just like standalone servers, so there shouldn't be any reason why you cannot have an active/passive/passive...

vivek_jain1 (8/18/2014)

---

Hiya Maddave,

What error does the Backup Exec job fail with ? Is the Advanced Open File option enabled in the backup job properties ?

Additionally, would you PM me the...

Phew! It finished after just short of 19 hours! All back to normal.

Still need to do the update, but we can manage this a lot better now, now that...

Hi Jeff, everything you had said is absolutely right and some of the questions you asked are ones I have asked myself. The application and therefore database was...

Seems so simple now!

Perfect thanks.

Perfect! Thanks so much.

I was on to something a tiny bit similar myself, but for some reason my code doesn't change the data at all.

declare @id bigint

set @id = 0;

With...

It's data that has come from an external source and is different to what is required for the internal sequence. In the real system, the external sequence starts at...