October 20, 2016 at 7:00 am
jasona.work (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server.
I am currently migrating 69 dev databases to new dev Windows 2016/SQL 2016 box.
Backups and copies done.
Logins next and then....
Restore :w00t:
Far away is close at hand in the images of elsewhere.
Anon.
October 20, 2016 at 7:38 am
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
October 20, 2016 at 7:57 am
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Good. Luck.
(From Tropojë)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 20, 2016 at 7:58 am
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
October 20, 2016 at 8:16 am
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
Watch it, you two, or I'll have to let the Hippo deal with you both!
October 20, 2016 at 8:33 am
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
*Grabs popcorn and relaxes on his seat to watch the show*
October 20, 2016 at 8:48 am
Luis Cazares (10/20/2016)
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
*Grabs popcorn and relaxes on his seat to watch the show*
Yup. I'm waiting for Lynn to release the Hippo. 😀
October 20, 2016 at 8:55 am
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
/me goes and gets a couple German Shepherds
Go ahead, make their day!
:hehe:
October 20, 2016 at 9:00 am
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
/me goes and gets a couple German Shepherds
Go ahead, make their day!
:hehe:
I refuse to concede this pork chop battle!
October 20, 2016 at 9:34 am
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data, the DBs are all TDE'ed, and I don't have (and couldn't get in the time available) enough room on the source server to run a backup to. So I'm backing up across the network to the new server...
At least I've got an all-day window to do this, but it gets boring watching the percentages...
Tell me about it. I've had to do that before. And then, right at the last minute, the backup fails because of a network error.
I swear, if you've jinxed me on this...
I have a very particular set of skills, skills I have acquired over a very long career. Skills that make me a nightmare for people like you. If you un-jinx me right now, you will never hear from me again. But if you leave me jinxed, I will find you, and I will feed you to the hippo.
:hehe:
Ummm. Oh, wait. I still have a pork chop launcher... BRING IT ON!
:w00t:
/me goes and gets a couple German Shepherds
Go ahead, make their day!
:hehe:
I refuse to concede this pork chop battle!
/me grabs a rasher of bacon. Throws it at Brandie
RELEASE THE HOUNDS!
October 20, 2016 at 9:40 am
Gazareth (10/19/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
First line: "Version 4.2 also lets you nest triggers"
I didn't get any further due to blacking out; came to 10 minutes later in the foetal position under my desk.
Colleagues tell me I let out quite the scream too...
Lesson learned, keep a comfort blanket (charlie brown style) under the desk and be good to the dust bunnies:-D
😎
October 20, 2016 at 1:27 pm
Geez, it's amazing how long it can take to backup a 150GB database across a network...
Finally got the migration done, customer reporting everything seems OK so far, Agent jobs seem to be working (some of them don't do anything until a file comes in to BCP into the tables, and have to do some weird decompression against the files first,) so I'm calling this a success!
And only an hour left in the day!
:w00t:
October 20, 2016 at 1:36 pm
jasona.work (10/20/2016)
Geez, it's amazing how long it can take to backup a 150GB database across a network...Finally got the migration done, customer reporting everything seems OK so far, Agent jobs seem to be working (some of them don't do anything until a file comes in to BCP into the tables, and have to do some weird decompression against the files first,) so I'm calling this a success!
And only an hour left in the day!
:w00t:
Well done, Jason. It's always nice when you get a big run done before leaving for the day.
October 20, 2016 at 1:52 pm
Eirikur Eiriksson (10/20/2016)
Gazareth (10/19/2016)
Eirikur Eiriksson (10/18/2016)
Just had a Blast from the past😎
First line: "Version 4.2 also lets you nest triggers"
I didn't get any further due to blacking out; came to 10 minutes later in the foetal position under my desk.
Colleagues tell me I let out quite the scream too...
Lesson learned, keep a comfort blanket (charlie brown style) under the desk and be good to the dust bunnies:-D
😎
Mark of a professional 🙂
October 20, 2016 at 2:56 pm
I stumbled across this old url today. It points to an article that tells yet again the cautionary tale of the importance of testing backups but it is also hysterically funny (“you know you’re in trouble if you have a developer in the server room asking about backups…”).
A few of you regulars commented on it at the time and I thought the author might appreciate it being resurrected and a new audience may enjoy it as well.
https://www.simple-talk.com/sysadmin/general/how-to-kill-a-company-in-one-step-or-save-it-in-three/
Viewing 15 posts - 56,371 through 56,385 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply