Yes.  We use 'A VENDOR' to backup to disk and tape.  With tapes moved / stored offsite on a regular/weekly basis.

February 20, 2019 at 9:02 am

#2022488

2/17/19 "An older offsite backup server was unearthed and revived. The last backup is in August of 2016"
From https://www.vfemail.net/incident.php

I guess they didn't use an offsite tape solution? ...

Thanks. I did try the run as admin before but maybe didn't check for any log files when I did.

Now after running as admin and after checking for new...

Yeah, tried a new DL but same result.

Fortunately, this server is one to be decommissioned within the next few months (although that never happens).

We still have...

Hi Sue,

No, nothing. Only a Release folder is in that sub folder. I searched the whole drive for anything new after running the setup but nothing. Really...

The first database is for redundancy and the second db is for reporting. They don't want to get kicked out every 5 mins.

So I thought, Log Ship every 5...

Thanks Lynn. I spotted that also. the missing "COMMIT TRAN "

Woo hoo 🙂

P

Thanks very much Sean.

I'll try that on a test server this time.

P

Thanks Lynn.

Apart from the deprecated code, do you or anybody else see any issues with my delete routine?

Why did the whole lot roll back?

P

Thanks. I was actually quoting your code, not using dynamic code.

My contract has ended, so I won't be putting this into production. Thanks anyway.

P

I'm testing the code on a dev server.

The "exec sp_addsubscription @sync_type = 'none' @article='all'...." is failing because I haven't dropped the subscription, I just dropped the article from...

Thank you. I appreciate that info.

BTW: I'm not trying to gloat about the size of the table or anything, just trying to emphasise we can't let...

The table is part of an existing publication with other smaller tables. We have created/duplicated a new table_2012 (partitioned) with a better partition layout etc and have it setup...

Yes Mike, I ususlly do that but in this case do I need to drop and add the subscription? I guess so, right.

Thanks

Try creating the table on the 2nd server using the same script as the source (1st)server. Looks like they are different.

P