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...
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
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...
July 13, 2009 at 3:44 am
Are the jobs failing & does the job history show any error. If so please paste the error.
July 13, 2009 at 2:18 am
You can do a point in time recovery till the time before update & get the lost data.
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...
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...
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...
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...
July 9, 2009 at 2:55 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.
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...
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 !!!
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...
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 !!!
April 16, 2009 at 11:49 pm
Viewing 15 posts - 16 through 30 (of 45 total)