Viewing 15 posts - 886 through 900 (of 2,897 total)
You can also use Replication, especially if you only need a subset of production.
If you can use transactional replication, then you have the option of close to real-time updates of...
July 19, 2011 at 10:24 am
I think SQL just works with the system date of the computer, and the time zone and DST settings, so I would think any error would be from incorrect...
July 18, 2011 at 12:38 pm
solomon.jernas (7/15/2011)
Could you give any example for encrypt & decrypt two column in a table ( ssn int, b_date datetime)i'm going to implement in production server..
Thanks
I hope you do thorough...
July 15, 2011 at 9:05 am
With a 2T database, I think after switching to Full recovery you could then take a differential to start the log chain. It may be faster than a full, if...
July 6, 2011 at 11:01 am
I don't quite understand the problem. You can automate all the steps.
I did something similar a while back with 2 sql servers on different domains.
June 30, 2011 at 6:50 pm
Thanks for the feedback. I'm heading on vacation for a bit, so I'm going to leave it alone for now, and it only runs once a month, so no rush.
June 26, 2011 at 4:13 pm
TableA, being inerted into, is a live production table, while TableB, being selected from is a temp holding table during a load process. Initially, the process did 1 big...
June 25, 2011 at 4:56 pm
Brandie Tarvin (6/20/2011)
Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.
Yes, I find...
June 20, 2011 at 12:32 pm
It would be helpful to give some information about the Dev environment & the Prod environment.
What is the same between them ? What is different ?
Do some basic research...
June 15, 2011 at 4:46 am
I've just started having this problem with some long running jobs. One job is an alert I set up for myself & I am the only recipient. It only happens...
June 14, 2011 at 8:19 am
Additionally, I think your new file will have to be in a new file group so that you can specify the objects to move.
May 30, 2011 at 10:26 pm
1) I suspect you mean the difference between a transaction log backup & tail log backup ?
Tail Log Information From Microsoft - http://msdn.microsoft.com/en-us/library/bb283410.aspx:
"In most cases, under the full or bulk-logged...
May 30, 2011 at 10:15 pm
SP4 doesn't seem to require a reboot or manual restart of services. (Recently installed on test server). However, I'll probably be doing reboots on the production boxes - just in...
May 25, 2011 at 8:12 am
I would like to nominate myself as an Acceptable DBA of 2011. Is there a category for that ?
May 25, 2011 at 8:00 am
You could rename the table to something more useful.
And next time you import from Excel, you get an opportunity in the wizard to give the table a proper name.
May 24, 2011 at 11:01 am
Viewing 15 posts - 886 through 900 (of 2,897 total)