Viewing 15 posts - 556 through 570 (of 620 total)
What you can do is set up a job to back the t-log up frequently and then have a job on the other server to restore the log to a...
October 28, 2008 at 10:08 am
Not sure what you are trying to achieve here. Clustering is essentially for fault tolerance NOT performance (load balancing), so active/active is not going to share your work load.
With regard...
October 28, 2008 at 6:38 am
NicDX (10/28/2008)
verified that you are authenticating using the correct username and password?
You must ensure that the username you are connecting with ie service account on one server has sufficient rights...
October 28, 2008 at 6:25 am
Verify that the user/service/account which is running the job/agent has enough rights to delete files from the location. Modify does not allow delete. So the account must have full access.
October 23, 2008 at 8:01 am
What is the point of having a point in time policy if the log is backed up once daily before the database. That would only be helpful if the database...
October 23, 2008 at 4:25 am
If you create a user with the server role 'process_admin', this user will be able to use the activity monitor. HOWEVER...
It will also be able to kill of processe.
Hope this...
October 22, 2008 at 8:09 am
Hi there and welcome to SSC. Didnt really understand your request but assuming you talking about how to script new windows logins in SQL 2005, please see below:
USE [master]
CREATE LOGIN...
October 22, 2008 at 7:46 am
Or, if you have done a full db backup and want to just squish your t-log, ensure db backup and set recovery mode to 'simple'.
Manually shrink the t-log (should...
October 22, 2008 at 7:29 am
Correct. There is no need to over complicate the plan (as long as its not to complex ie TSQL and other bespoke tasks).
I keep most of my plans to one...
October 17, 2008 at 3:13 am
Hi there,
Just re-read your original question and realised my response ignored your question.
Rather then scheduling the different steps/parts to run at different time, use the progression/inheritance lines.
In that way...
October 16, 2008 at 9:55 am
E'oh 🙁
Just seen everyones response, that'll teach me for not hitting F5.
Sorry guys, didn't mean to go repeating everyone else's point.
Let me know what you decide on Jackal as we...
October 16, 2008 at 9:48 am
So weird... I was looking into this on Monday and since then there have been several posts to the same subject.
Does see strange the ways it’s labelled. You would assume...
October 16, 2008 at 9:44 am
Steve Hindle (10/16/2008)
October 16, 2008 at 9:36 am
magennis.weate (10/13/2008)
you could try using xp_cmdshell (if it is enabled)
That certainly works for me. xp_cmdshell is useful for passing commands to the OS but a word of warning, it...
October 14, 2008 at 5:01 am
Viewing 15 posts - 556 through 570 (of 620 total)