Viewing 15 posts - 16 through 30 (of 45 total)
Also make sure the maintenance job is running with a job owner who has all sysadmin rights . At times the owner may get changed in job & be one...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 22, 2009 at 2:47 am
Multi server admin normally helps you with the jobs mainly when you want to configure similar jobs on many servers. you can chck out
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 13, 2009 at 3:51 am
If you run the WMI service under any account other than the LocalSystem account, you can cause permission errors and access errors.
To resolve this error, you must configure the WMI...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 13, 2009 at 3:44 am
Are the jobs failing & does the job history show any error. If so please paste the error.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 13, 2009 at 2:18 am
You can do a point in time recovery till the time before update & get the lost data.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 13, 2009 at 2:13 am
You won,t be able to rollback the data once it is committed. You can try doing a point in time recovery & get back the lost data.
If not you...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 5:02 am
Returns a result set in a readable version of the replicated commands stored in the distribution database, and is used as a diagnostic tool. This stored procedure is executed at...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 3:19 am
Just run the RESTORE DATABASE WITH RECOVERY command to get the DB in to a usable state.
When restoring a database you get three options for the final state of the...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 3:02 am
Logshipping is a good solution for your scenario even though there are few manual tasks to be taken care of to make the secondary server active. Once you make the...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 2:55 am
k
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 2:48 am
Make sure you the account(job owner) with which the jobs are running has full access/sysadmin rights or change the owner to sa & then run the job.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 2:46 am
Check if you have full access to the database. Also you can use the enterprise manager --> DAtabase--> Stored proc --> go to the tab where you have permission option...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 9, 2009 at 1:11 am
Hi ,
Just try giving the Ip address of the server in place of servername in DataSource field. Connection info: Data Source=sbsserver\sqlexpress
Have a nice day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
July 3, 2009 at 3:43 am
Hey Thanks for the responses but I have resolved the issue myself. The problem was due to the MSXML6 Parser which had got installed in the laptop. The higher version...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 24, 2009 at 12:36 am
Hi,
Instead of the Link server name, type the IP address of the server & then try.
Have a nice Day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 16, 2009 at 11:49 pm
Viewing 15 posts - 16 through 30 (of 45 total)