Viewing 15 posts - 1 through 15 (of 22 total)
It was a while ago, but in my case it was just a case of dropping the database onto the server. I generated the database by installing the software on...
March 7, 2014 at 10:50 am
Similar to the above, I have a supplier who wants to install an app but requires the Oracle extension pack installed on the SQL server for compatibility between their app...
March 8, 2012 at 7:41 am
Indeed I would.
I am taking the approach of writing an asp web page which will mimick the restore functionality of the desktop app but take away the need for the...
July 8, 2005 at 4:09 am
During a backup the transactions must get commited else a large database would quickly grind to a halt, but they don't. I believe the backup process notes the current state...
June 30, 2005 at 6:09 am
What I'm asking is how to get the output from jobserver.jobs.script method to produce the same/similar script to that generated by EM for a job. The bit that differs is...
March 22, 2005 at 3:42 pm
Paul, I think you are getting confused. I have only showed a snippet of one script which shows the DMO method I am using
Jobserver.Jobs(' 1 ').Script(68,"script_file.sq")
Admittedly I am using the...
March 17, 2005 at 3:05 pm
I believe the delete part of a plan (assuming you ahve configured for delete afetr X days etc) only kicks in after the backup part. This means that if there...
August 11, 2004 at 3:56 am
Agreed, simply is good and remember some basics. I think one of the options used a function on the column before testing ! Optimisers don't like this and are unlikely...
July 10, 2004 at 3:02 pm
Assuming the crash isn't recoverable on re-start.
Depending on the type of failure you may/may not be able to dump the current on-line log to bring you right upto date
To get...
July 10, 2004 at 2:33 pm
The Agent requires a sysadmin account within SQl Server.
If BUITLTIN\Administrators isn't sysadmin or doesn't exist the I guess you need to use another account other than system.
A windows domain level account...
July 10, 2004 at 2:18 pm
Further to this, I am currently executing the command which is found in step 1 of the job from the system tables. This then executes synchronously thus no need for...
June 16, 2004 at 9:36 am
Did you get a solution to this ? I am looking to do something similar re. Sart job, wait for job to complete before moving on in...
June 16, 2004 at 9:02 am
Check your database has a valid login for its owner. I have just had a similar message and noticed the owner is blank when viewing via taskpad in Enterprise manager....
June 9, 2004 at 2:10 pm
I am facing a similar situation.
I have proposed three options : Log shipping, DTS and Transactional replication.
Log shipping is a batch update as frequent as required, however, the standby won't...
May 21, 2004 at 3:37 pm
If you schedule some maintenance plan jobs and then use the Profiler you'll get a better understanding of what the jobs are doing.
In brief : The jobs call a...
April 7, 2004 at 12:53 pm
Viewing 15 posts - 1 through 15 (of 22 total)