Hi George,

Thanks for getting back. I'll see if I can try that.

Perry, my error is as follows

Cannot open backup device G:\SQLBackup\dbname.bak. Operating System error2(failed to retrieve text for this error....

Hi Perry, thanks for getting back, curiously I did not see anything in the logs, I did click the hyperlink but I can't remember what was in it. I read...

Thank you Gail, awesome as usual.

Scott,

Yes, we are doing something similar, we are increasing a column (14,5) to (17,5).

Regards,

D.

Hi faisalfarouqi,

Thanks for the repy, the (possibly) crucial bit of info I missed out was that the 2012 was not using the standard ports.

In the end I created an alias...

Hey,

If you save the results to file (a little button on the tool bar before you execute the the SP), then just copy the file to where you want it,...

Hey,

I just found this new SSDT add on, not sure if its a comparison tool or not though, and it could be an issue with the other database being in...

Hey, I really appreciate the time everyone has taken to answer this post.

Could you restore the full backup on your secondary server and leave log shipping running, then take a...

Hello Ten Centuries, thanks for responding.

Backups are the default 15 minutes.

Do you have the option of pausing the log shipping, grabbing the last log backup and applying that (with the...

Hi Grasshopper,

Thanks for getting back, what I am wondering in that case is, in regards to backing up and restoring the transaction logs to the mirror (which are already getting...

Hello,

I am looking to run this as well, are you saying that sp_mergemetadataretentioncleanup needs to be run on the subscriber first and then the publisher to avoid any issues?

You mentioned...

Hello,

Thank you for taking the time to answer my post, I had read the article previous to posting here, but in this case the Mirroring is already in place, and...

Hello Jeff and everybody.

To confirm it is SQL 2008 R2 64bit, build 10.50.4276.0

It was SQL server running a bulk insert job, I thought it was direct, but it seems to...

Thank you for reading and responding so quickly, Hmm, I'd have to check, but I'm fairly sure it's 2008 r2 64bit, I can confirm and come back Monday. Have you...

Hi everyone,

Thanks for taking the time to reply, log shipping is currently the only form of t-log backups. I'm not stopping the log shipping no. I'd prefer to do t-log...

Thank you.

Regards,

D