Viewing 15 posts - 721 through 735 (of 1,157 total)
Upgrade advisor will not advise for changing the compatiability mode of databases, after upgrade. If you read the error message, it says that this version of Upgrade Advisor cannot be...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 10:53 am
You may use the COPY_ONLY option while taking FULL backups. This does not break the log chain. Please refer this.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 7:33 am
Any error messages that you get? Looks like an interview question to me
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 7:23 am
SQL Server service account is unable to add/remove SPN from the AD. Most likely it does not have the privileges.
However, I don't expect this to prevent SQL Server from starting...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 5:17 am
Yes, most likely the password got expired or reset. Please check
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 4:42 am
Data files will still there be on the drive. But please take the BACKUP of database on SQL Server before uninstalling. As mentioned by Gail, configure Windows Cluster and then...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 4:37 am
Here is one on MSDN
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 4:35 am
Does it Recover anytime after restart? When it is in Recovering state, the entries in the SQL Server Error Log will give more information on the issue
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 25, 2010 at 3:23 am
One more example[/url] at SSC using SSIS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 10:49 pm
Here is one such example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 10:48 pm
Does this now suggest that sp_dropserver and sp_addserver are now obsolete
Thanks .
They are not obsolete. Please refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 4:26 am
When you run the job, does the backup file gets created on E drive? Also you may use this query to check the backup status.
SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],
B.ESTIMATED_COMPLETION_TIME/60000 AS...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 4:22 am
You may use the Scheduled Reporting feature in SSRS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 1:23 pm
You can download it from here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 10:07 am
Navigate to SQL Server Agent --> Alerts. Right Click and select New Alert. In the new alert enter the Error Number and in response select "Notify Operators"
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 23, 2010 at 9:30 am
Viewing 15 posts - 721 through 735 (of 1,157 total)