Viewing 15 posts - 61 through 75 (of 137 total)
You could have a DNS entry created with the new name, and the instance's IP address.
December 17, 2013 at 11:17 am
Here are some examples from my own experience, where I have had to use RDP:
1) Get a call from the users that the application is very slow, and I can't...
December 17, 2013 at 11:05 am
1) Dell Venue 8 Pro tablet. My Lenovo Ideapad purchased at the beginning of the year has Windows 8, but no touch screen. My wife has a Nexus 7 and...
December 13, 2013 at 8:15 am
Whoops, didn't see the 2000 part first time around.
November 26, 2013 at 2:21 pm
Start with the sysjobactivity table, and you should be able to come up with something that fits your needs.
November 26, 2013 at 12:38 pm
Backup and restore require far too much hands on DBA work. I've mentioned this before here, but back in the 1980's, mainframe DB2 just required a restore database statement to...
November 21, 2013 at 10:47 am
Glad to be of help. My current shop moves a lot of data back and forth from the mainframe, and we have lots of these jobs. In general, batch jobs...
November 12, 2013 at 10:13 am
You should find out what they are doing every 15 minutes, and what will or will not happen if they don't run for a while. You are going to...
November 12, 2013 at 9:45 am
Another such product is Skybot, http://www.skybotsoftware.com. It claims to run across multiple platforms, such as SQL Server, Oracle, SAP, etc.
November 6, 2013 at 10:44 am
This seems to be a holdover from the old days, when servers had local disks, tape drives, and tapes were expensive. And of course, backup tapes were often un-readable. But...
October 30, 2013 at 9:33 am
A couple of things caught my eye:
1) The jobs would run if the cluster was actually running active/active with the instances running on the opposite nodes.
2) After the failback,...
October 24, 2013 at 11:09 am
Also make sure that the permissions are set at both the share and file level. It's easy to forget one of the other.
October 21, 2013 at 11:14 am
It can be done with 3rd party tools, such as Quest/Dell NetVault LiteSpeed. Probably others as well.
October 16, 2013 at 1:16 pm
In the meantime, you can create a view for the table(s) with the non-sensitive columns, and lock down access to the base table for almost everybody.
October 15, 2013 at 1:47 pm
Here are a couple of things that I routinely deal with:
1) If you routinely refresh data in a test server, it's much easier to restore a database than to more...
October 9, 2013 at 1:37 pm
Viewing 15 posts - 61 through 75 (of 137 total)