@scottalanmiller said:

@IT-ADMIN said:

since i have a connection error, it means that the connection use local account, because all local acconts were deleted (when i go to users and groups i found only 2 account : administrator and guest)

I am not aware of using local accounts for SQL Server. The SQL Server runs on the box that you put the Domain Controller on or on a separate server?

There are two, very misleading types of accounts with SQL. Local and Windows Authentication. Local means SQL only, stored in the master security table. Windows authentication means that it's setup to read the GUIDs of IDs within Windows, be it local or domain. You have to add them in separately.

IT-ADMIN, if you have the sa account, you might be able to pull yourself out of the fire. Get the logs, find out what needs to be recreated, then you will have to rebuild the accounts by hand and reset everyone who might have been accessing it. Certainly better than the current hands in the air pants on fire situation.

Best part about this is that the porn sites know how to handle their shit properly.

c:\Program Files\ISC BIND 9\bin>dig pornhub.com +trace

; <<>> DiG 9.11.0 <<>> pornhub.com +trace
;; global options: +cmd
. 411 IN NS f.root-servers.net.
. 411 IN NS g.root-servers.net.
. 411 IN NS h.root-servers.net.
. 411 IN NS i.root-servers.net.
. 411 IN NS j.root-servers.net.
. 411 IN NS k.root-servers.net.
. 411 IN NS l.root-servers.net.
. 411 IN NS m.root-servers.net.
. 411 IN NS a.root-servers.net.
. 411 IN NS b.root-servers.net.
. 411 IN NS c.root-servers.net.
. 411 IN NS d.root-servers.net.
. 411 IN NS e.root-servers.net.
. 411 IN RRSIG NS 8 0 518400 20161103050000 20161021040000 39291 . RCis/yNeB+7kBF3X0LA+q9zk+0kI65mbfaLLAwQIEjrLI2hvH8k6azXm kXfkoVtpWaVPrg4Ssr+8k2f9BOMfapO4ckIJDJQ51DlSoselGXngerFv XuSnnxQ7UYjUH448GNHJ7KqX1efbww7Gv8Gu8oSr5w29Tt7RGKtT+n4b 1IM8bu3FkRMKeMEbij83onxyFQfBEWgI1w5h8ZECKuikvT8NVAExGfZq b+yDb61YZWE51LoFdnbIND+dnnzLNgvNUUy/idcPsNxx0T/8A0W0YiD6 gWU7fsxyoW+Q7I7VAQzmLZQanSKie6GAX1DD7wI1o/zbbXEsy9fW42/I L304ZA==
;; Received 647 bytes from 10.0.131.21#53(10.0.131.21) in 2 ms

com. 172800 IN NS l.gtld-servers.net.
com. 172800 IN NS j.gtld-servers.net.
com. 172800 IN NS c.gtld-servers.net.
com. 172800 IN NS d.gtld-servers.net.
com. 172800 IN NS i.gtld-servers.net.
com. 172800 IN NS f.gtld-servers.net.
com. 172800 IN NS m.gtld-servers.net.
com. 172800 IN NS k.gtld-servers.net.
com. 172800 IN NS b.gtld-servers.net.
com. 172800 IN NS h.gtld-servers.net.
com. 172800 IN NS e.gtld-servers.net.
com. 172800 IN NS g.gtld-servers.net.
com. 172800 IN NS a.gtld-servers.net.
com. 86400 IN DS 30909 8 2 E2D3C916F6DEEAC73294E8268FB5885044A833FC5459588F4A9184CF C41A5766
com. 86400 IN RRSIG DS 8 1 86400 20161103170000 20161021160000 39291 . f/EDEO/LUPJgK0mpTgQSA609jvCwLZwvVeKV+vz3VzXLQlbb5XRsNBu4 /yvgyomTudqWqdrtYxQGs5DrC/RU3kuN+woEAt6+Gvwz9ROx3PrVZGEt 67vItYvjVICEIM2wPgTg93xHXBNP0roI9Q93fjWB393E8+P05etDaf0Q MKXc8xZn8pQJoEbY1Xj0xJhcVLOsCFB6P5yod81dg1Wa/e4V5x5kjodj AYkgIewcJu/jPb/IeaQrXNppXpGTj2hxFD8pPA4J6NbFg1yZoS7FckV5 CSXO20M9tXP/uMLGP3t1GZLfAAmsWcJH+Ca8xPYjqmrwfYVdpU2MqFUq USADug==
;; Received 863 bytes from 192.36.148.17#53(i.root-servers.net) in 40 ms

pornhub.com. 172800 IN NS ns1.p44.dynect.net.
pornhub.com. 172800 IN NS ns2.p44.dynect.net.
pornhub.com. 172800 IN NS ns3.p44.dynect.net.
pornhub.com. 172800 IN NS ns4.p44.dynect.net.
pornhub.com. 172800 IN NS sdns3.ultradns.net.
pornhub.com. 172800 IN NS sdns3.ultradns.com.
pornhub.com. 172800 IN NS sdns3.ultradns.org.
pornhub.com. 172800 IN NS sdns3.ultradns.biz.
CK0POJMG874LJREF7EFN8430QVIT8BSM.com. 86400 IN NSEC3 1 1 0 - CK0Q1GIN43N1ARRC9OSM6QPQR81H5M9A NS SOA RRSIG DNSKEY NSEC3PARAM
CK0POJMG874LJREF7EFN8430QVIT8BSM.com. 86400 IN RRSIG NSEC3 8 2 86400 20161025044429 20161018033429 6404 com. AH9irkzaB4cAY3eWsoMK1EIRWM9BQnOHCWiZXIeS2XLjnqeV4utkWlLR 4OAWffKjOwk4w/EHjpzyh0Ow3W0AJ+DSUcqTlyw9q8PlCh52dunQp75u HwaidnXXIAWFGQLIqPeD2/GNw7d159vzEgS7kp3VosK+2icfw3hbZ39B Us0=
16Q870P2VU4N1BNA80CJC46DDV5BI6P7.com. 86400 IN NSEC3 1 1 0 - 16Q99C2CTQADNLJVKCG929NVIVD5ATQU NS DS RRSIG
16Q870P2VU4N1BNA80CJC46DDV5BI6P7.com. 86400 IN RRSIG NSEC3 8 2 86400 20161027043207 20161020032207 6404 com. H8G4ZjSDJ/AXvbYLmnKvShwzS++18oZdvQa3pJnKznwC8qyhtdnuE9PZ Ot3vKE7HWGjG9xRzCkBGNfKPJcr9q1DMQQTcoRN5eeb7DVY7tocyMnbm lt/ZzFu1rAuD32x7k/x+oDKOXTI2b0klNB3F3xKTBXmRL4bBOSVEii8z O/g=
;; Received 885 bytes from 192.12.94.30#53(e.gtld-servers.net) in 33 ms

pornhub.com. 300 IN A 31.192.120.36
pornhub.com. 86400 IN NS ns3.p44.dynect.net.
pornhub.com. 86400 IN NS ns4.p44.dynect.net.
pornhub.com. 86400 IN NS sdns3.ultradns.net.
pornhub.com. 86400 IN NS sdns3.ultradns.com.
pornhub.com. 86400 IN NS sdns3.ultradns.org.
pornhub.com. 86400 IN NS sdns3.ultradns.biz.
pornhub.com. 86400 IN NS ns1.p44.dynect.net.
pornhub.com. 86400 IN NS ns2.p44.dynect.net.
;; Received 264 bytes from 156.154.142.3#53(sdns3.ultradns.biz) in 4 ms

They used redundant name servers, so when Dyn went down, people could still get their rocks off.

Might just be easier to slap on a cheap-o machine with a SCSI card and access it that way.

If this was a drive array, it might be different. Although tape libraries usually support the standard SCSI commands, once you obscure the process using devices rather than talk to it directly, it might not work as expected, e.g. cycle tapes when requested. I used to work on 42U tape libraries and I would never try to jerry rig one to work.

Depending on your backup solution, and especially since you have a SCSI tape library, I would go ahead and grab me as many disks as I can and make me a disk to disk to tape system. The clients stream straight to disk, your local machine streams to tape. No muss, no fuss, and can be done easily with even the Windows backup client. And it's usually faster and offers a bit of retention from waiting for tapes to return from the vault.

Didn't say what NAS they have, but NetApp has the ever so useful Snapmirror, which will replicate all the data to another device automagically.

http://www.netapp.com/us/products/protection-software/snapmirror.aspx

Performing replication is gonna depend on how fast they want to recover. Using things like Veeam to send data back and forth is fine, but the delta would be kind of a problem. Using snapmirror would replicate in real time and recovery would be within seconds.

I would beef up the two servers, slap all of the VMs on one, run Veeam to clone across to the secondary for local redundancy, keep critical data on the NAS and shuffle the data over to the offsite backup with the other NAS.

@scottalanmiller said:

@PSX_Defector said:

One of the things I tell lots of people is not to rely on luck to get you through a gambling session. But this situation, as a gambler, you need to know how to hedge your bets. Your gonna reach another problem and go head strong into it, like laying down $100 on a table without knowing what the game is. You need to think through the entire scenario, what will happen if you do this, what is your fallback position, what is your backout procedure, how do you know it's done and satisfactory.

One more thing that has to be considered - the reward. How big is the payoff? In this scenario, the payoff, had everything worked perfectly, was effectively zero. There was risk without potential reward. That's a big deal too. He would not really have benefited here, even if things had not gone poorly.

Agreed. This is betting on every horse in the race. Yeah, you win, but what do you get out of it? Maybe a dollar or two assuming that the longshot came in. If it was the 2-1, you are out money on the process.

See the road ahead, understand what is next, what you next move is, and it will usually work out. Something some folks don't understand.

@IT-ADMIN said:

you know guys, i thinking of promoting the server application again hhhhhhhhh
i know some of you will insult me looooool
what do you think guys

@Dashrender said:

@PSX_Defector said:

Didn't say what NAS they have, but NetApp has the ever so useful Snapmirror, which will replicate all the data to another device automagically.

http://www.netapp.com/us/products/protection-software/snapmirror.aspx

Performing replication is gonna depend on how fast they want to recover. Using things like Veeam to send data back and forth is fine, but the delta would be kind of a problem. Using snapmirror would replicate in real time and recovery would be within seconds.

I would beef up the two servers, slap all of the VMs on one, run Veeam to clone across to the secondary for local redundancy, keep critical data on the NAS and shuffle the data over to the offsite backup with the other NAS.

This would require a significant storage purchase at minimum, but not a bad idea, assuming the system will hold enough disk that is.

Considering what they are probably using, I bet it wouldn't cost much. We ain't talking about my Cisco UCS blades with NetApp SANs. I would bet the "server" is some off the shelf junk from Fry's and the NASes are some kind of Buffalo device. Don't bother with PCI-E SSDs and fancy Fibre Channel SANs, this is fairly simple in the grand scheme of things. Some high quality SATA would do them just fine.

First, take the first machine and P2V it into the second machine. No point leaving it bare metal. Then take the first machine, nuke and pave then install Hyper-V or ESXi stand alone. Move your three VMs over to the first machine, nuke and pave the second machine with Hyper-V or ESXi, setup Veeam replication between them, then map the NAS through whatever way you need to for it to keep data onsite and off.

@coliver said:

@scottalanmiller said:

@coliver said:

Everything I've read (from some enterprise users) seem to suggest that glacier retrieval can indeed go into the 24 hour time frame.

And I've heard longer. It's because it is going to physical tape retrieval.

I didn't realize it was physical tape. Wow. I thought tape was getting to the price/gb line where disk is less expensive. Is tape that much more reliable?

https://www.tape4backup.com/29080.php?gclid=CIrgj9ibwsgCFQIOaQodLecN1A

Where can you get 2.5TB worth of storage for under $40?

Mind you, that's the physical capacity. Compression in backup schemes can be super powerful. I've had LTO4 tapes not even get near capacity after compression for a week's worth of full backups.

@coliver said:

@MattSpeller said:

@hubtechagain lol - you're cleaning me out bud! $6.50 is my final offer

What is that like $4USD?

Nah, it's about tree fiddy!

@scottalanmiller said:

"Pile" is not a term for a group of files

You just don't know the awesome power of the pile.

@scottalanmiller said:

I might not have followed this correctly but... PTR (Reverse DNS) records have to be done at the IP Address point, not with your DNS provider. Whoever does your A and MX records can't be the company with the PTR record. Your ISP has to do the PTR record. The ISP at which your MX record points.

Incorrect. It can be the same one, but someone has to have delegation to perform it.

https://www.arin.net/resources/request/reversedns.html
https://www.apnic.net/services/services-apnic-provides/registration-services/reverse-dns
https://www.ripe.net/manage-ips-and-asns/db/support/configuring-reverse-dns
http://www.lacnic.net/en/web/lacnic/guia-de-sistema-04
https://www.afrinic.net/library/corporate-documents/216-how-to-request-reverse-delegation-in-afrinic-region

And for the most part, most ISPs, especially home ISPs, do not delegate out permissions.

@scottalanmiller said:

That's weird. I've had a lot of Verizon phones and the SIM card was always optional. I've had them and only added SIM cards later, remove them when not needed. Never affected how it worked in the US.

It was part of the change with moving over to LTE.

"Technically" you can use an AT&T SIM on a Verizon phone to access AT&T's LTE service, depending on the device and if it can hit the right channels. The base services are still CDMA for voice and other data services, but get info from the SIM for registration versus the old school IMEI info. There are registration issues and various other things that make it not work, but LTE follows GSM encoding so in theory it will work.

Devices designed around GSM usually can't talk CDMA, but since CMDA is a limited market most of their devices also speak GSM. All under one SIM.

@scottalanmiller said:

@Our-Tech-Team said:

I've never used or worked with Samba so dont know anything about it. The AD I thought was great for them as they want to have more 'control' over users, add more security to the network and manage permissions on folders much better. I'm familiar with AD so thought it would suit them well.

Samba is just as much AD as Microsoft's DC is. Both are AD, just one is done from an open source project and one from Microsoft. It's not that Samba is not AD as well.

Samba is NOT AD. AD is a complete architecture including LDAP, DNS, and various other items. Samba functions in the old "Domain Controller" method, a single list of usernames and passwords in which to authenticate against. In AD, there is no DC, there are Global Catalogs. Domain controller emulation, a part of the FSMO roles, is not necessary to run and is only there for backwards compatibility. In an AD environment, Samba can function as a PDC emulator, but it cannot hold other GC roles, so it becomes kind of useless.

To the end user, they are functionally the same. To the admin, they are very different.

@scottalanmiller said:

And then the question is also... why not 12Gb/s SAS?

If that's the determining factor, then why not 16Gbps FC, or even the upcoming massive speeds?

http://www.networkworld.com/article/2174282/lan-wan/fibre-channel-will-come-with-32-gigabit--128-gigabit-speeds-in-2016.html

Of course, if we are talking about pure speed with regards to interconnects between machines, then Infiniband blows them all away:

https://en.wikipedia.org/wiki/InfiniBand

Fibre Channel has it's place. It's much more scaleable, why do you think every multi-tenant environment uses them? SAS interconnects are good for onesie/twosie type things, but when you need to scale more and more storage, it's much easier to pop it in the FC fabric. We provision new storage in a matter of hours integrating into our already large environment. The FC storage devices tend to be much more useful than straight SAS connected storage as well, with the ability to manage the suckers without so much as a blip in downtime.

If money is no object, I would buy Infiniband infrastructure and storage. If I need lots of it on the cheap, SAS. If I need more features, Fibre Channel.

@scottalanmiller said:

@Carnival-Boy said:

People seem to assume Access will only work with Access databases (Jet), when it works brilliantly with other databases, especially SQL server but I've written apps based on Oracle. I mostly use it with SQL Server these days. Whatever you use, the database should reside on a server not a desktop.

I'm very aware that it talks to SQL Server, that's the only way that I would ever consider using it, but was unaware that it works with other options. Will it talk to the big two: MariaDB and PostgreSQL or at least Firebird?

It's called ODBC.

I used Access to connect to my AS/400's DB2 server. As long as ODBC is presented to the client, it works just fine.

@travisdh1 said:

@PSX_Defector said:

@ryan_do said:

A few other perks include reimbursement of the cost of your Internet connection

How about paying for my OC3?

A personal OC3? Want to run their backup data center do you?

Be surprised how cheap it can get on contract from some CLECs and even some ILECs.

Last time I spec'd out a pipe from AT&T, with an OC3 to the office and some colo space in a DC near my house, a 100Mbps ethernet loop into the cage would only cost me about $900 a month. Of course, that doesn't include internet access, just a dumb pipe straight to the DC. I would mooch off whatever I could get from there. Even then, if I had to buy access, would probably run me ~$600 to $800 for AT&T.

In certain parts of the country, you can get some serious bandwidth for reasonable prices. With cheap access, I was thinking of running a fax service from the house. Some CLEC was offering $1200 DS3 pipes (45Mbps) with a full PRI a while back. Combine that with some cheap equipment, I would have a reasonable revenue stream for pretty much nothing.

@travisdh1 said:

@PSX_Defector said:

@Dashrender said:

@PSX_Defector said:

@Dashrender said:

@John-Nicholson said:

With De-duplication and Compression and RAID 5/6 Flash drives are cheaper than 10K RPM drives. We did the price comparisons with VSAN 6.2 came out and 10K is officially "dead" unless all your data is encrypted or something.

What are you using for De-Dup and compression? Is that something native in hypervisors now? if not, it adds to the cost column.

There's dedupe in Win2K12 at the OS level, assuming you are deduplicating NTFS file systems. If you are using encryption, that's the only way you will be able to dedupe data.

We use Pure Storage SANs, which support native dedupe at the block level. And it appears that VSAN supports block level dedupe as well.

https://blogs.vmware.com/virtualblocks/2016/02/10/whats-new-vmware-virtual-san-6-2/

Well, you're paying a LOT for those hardware platform - so at that point the extra space gained makes the SSD definitely more worthwhile performance wise. But not many SMB's are dealing with those things.

Which is very true. I work for a multi-tenant environment, so it's worth a few bucks to get the performance edge on those things. Dedupe is just an added bonus.

Which also brings up the fact that one should be hosting with us! We have the hardware one can only dream about. Why try to keep up when you can spend the cash on hosting which will take care of all of that for you?

Which is what company? The profile here doesn't say, and it's kinda silly to not get a good self-promotion in with that!

For various reasons, I don't mention who I work for, be it my previous employer Big Red V or my current one. Gotta maintain separation of professional and personal life.

Let's just say it's not Amazon, but if you follow cloud hosting, you would know who we are.

@Jason said:

@PSX_Defector said:

@travisdh1 said:

@PSX_Defector said:

@Dashrender said:

@PSX_Defector said:

@Dashrender said:

@John-Nicholson said:

With De-duplication and Compression and RAID 5/6 Flash drives are cheaper than 10K RPM drives. We did the price comparisons with VSAN 6.2 came out and 10K is officially "dead" unless all your data is encrypted or something.

What are you using for De-Dup and compression? Is that something native in hypervisors now? if not, it adds to the cost column.

There's dedupe in Win2K12 at the OS level, assuming you are deduplicating NTFS file systems. If you are using encryption, that's the only way you will be able to dedupe data.

We use Pure Storage SANs, which support native dedupe at the block level. And it appears that VSAN supports block level dedupe as well.

https://blogs.vmware.com/virtualblocks/2016/02/10/whats-new-vmware-virtual-san-6-2/

Well, you're paying a LOT for those hardware platform - so at that point the extra space gained makes the SSD definitely more worthwhile performance wise. But not many SMB's are dealing with those things.

Which is very true. I work for a multi-tenant environment, so it's worth a few bucks to get the performance edge on those things. Dedupe is just an added bonus.

Which also brings up the fact that one should be hosting with us! We have the hardware one can only dream about. Why try to keep up when you can spend the cash on hosting which will take care of all of that for you?

Which is what company? The profile here doesn't say, and it's kinda silly to not get a good self-promotion in with that!

For various reasons, I don't mention who I work for, be it my previous employer Big Red V or my current one. Gotta maintain separation of professional and personal life.

Let's just say it's not Amazon, but if you follow cloud hosting, you would know who we are.

I thought you were still with the Big Red V?

Nope, they shitcanned three quarters of the US based staff last year. I walked out $10K richer, a new job in two days, and a pay raise.

If you are still hosting with them, flee as fast as your contract will allow you. They recently went through another round of shitcannings, this time it was management. They lost great people, and is no longer the same company I knew.

@scottalanmiller said:

@PSX_Defector said:

@scottalanmiller said:

@Dashrender said:

To me it feels like the author is still approaching it from an old school disk performance perspective. One that perhaps wasn't ever really valid (but maybe it was).

I wouldn't call it old school. This was always a silly practice. It's more of just not understanding why things were done and applying them at the wrong time. He is, I think, confusing 1990's array tuning with partition log growth protection.

What, you mean to tell me putting my database on the inside tracks of my disk is no longer valid? What about when I use my SSDs, surely they will appreciate the lower access time of being closer to the controller!

OMG short stroking.... it's been forever since I heard people talking about that.

Last time someone mentioned it to me was back in 2011. Had to correct the fool about the fact he was running on a huge HP 585 using 15K RPM SAS drives. Even if we could lay out the sectors that way, it was no longer applicable because the controller was the bottleneck at that point.

These old ass ways of thinking still permeate various circles. Especially in old school mainframe guys, the ones who don't giggle when you mention you once had a Wang.

You can also block it at the SIP level with your provider. Do that along with international dialing, save yourself some headache.