Viewing 15 posts - 1 through 15 (of 17 total)
All - thanks for your assistance- The issue was with bad data.
June 17, 2016 at 7:16 am
On the table where it inserts the data.
We had issues with that table and had to import data from last good backup. After that we have this proc failing with...
June 16, 2016 at 12:51 pm
Will this be applicable for sql server 2014? ... If not is there a different way to handle this without changing values in registry
June 10, 2015 at 6:52 am
You don't have to create registered server again....
All you need to do is ....
Right Click on your old 2008 CMS and click on tasks and export those servers and use...
April 20, 2015 at 7:07 am
I see two different errors in that message....
1. Permissions Issue
2. Server/Instance connection issue
Can you make sure the account which you're using to run the job has sysadmin rights.....
For the second...
April 20, 2015 at 6:53 am
This looks like an AD error. Please contact your system administrator and provide the error info and they should be able to rectify the issue....
Dropping the login and re-creating...
March 30, 2015 at 6:20 pm
Can you follow the below steps....
1. Right click on the maintenance plans and click view history.
2. Open the backup Job which is failing and click on the step where it...
March 30, 2015 at 1:10 pm
Can you provide more details on what error are you getting?
Can you check the SQL Server error logs as well for more details?
March 30, 2015 at 12:54 pm
I would rather restore the database on my test server with a different name and use the import/export wizard and import the data using the query option, into the table...
March 30, 2015 at 7:31 am
Thank you!
After the database refresh, when i re-apply the permissions extracted before the refresh, I get complains from the users about connectivity issues.
This is because the SID's of the logins...
March 30, 2015 at 7:26 am
In general, it all depends on the application requirements.
First thing would be to gather the information from the developer who will be supporting that application on things like what exactly...
March 27, 2015 at 2:34 pm
Database refresh:
When someone asks you to refresh a database, please be sure to ask them the below source and destination server information...
Source Server:
Server Name: PROD\Inst1,12000
Database Name: SQLSERVER
ENVIRONMENT: PROD
Destination Server:
Server Name:...
March 27, 2015 at 2:20 pm
Script is really good and it helps a lot.
Does this script resolves the issues with Orphan Users?
If not it would be good if we include that portion in the script...
March 27, 2015 at 2:17 pm
Are you trying to login locally from your machine or from the server(try both ways)?
Can you check if the SQL Server Services are enabled?
Can you check the error-log on the...
March 27, 2015 at 1:53 pm
Viewing 15 posts - 1 through 15 (of 17 total)