http://www.petri.co.il/forums/ For issues related to Microsoft SQL Server 2008/R2. en Thu, 23 May 2013 04:02:24 GMT vBulletin 60 http://www.petri.co.il/forums/images/steelblue/misc/rss.jpg http://www.petri.co.il/forums/ http://www.petri.co.il/forums/showthread.php?t=63419&goto=newpost Tue, 14 May 2013 09:53:44 GMT Hi,

I've been getting this error for weeks now and cannot find a resolution.

An error pops up every morning regarding that the database auto-protection has failed.
This doesn't happen on any other server we have SQL/Messaging/AD.

"One or more databases could not be protected automatically because auto-protection failed. If the databases belong to a SharePoint farm, then the farm recovery points will continue to get created without these databases. (ID 32511)"

"1) To fix auto-protection, resolve the errors and run AutoProtectInstances.ps1 from DPM Management Shell.
2) If the databases belong to a SharePoint farm then go to the Protection tab and run "Modify Protection" for the protection group containing the SharePoint farm. In the wizard, expand the SharePoint front-end web server node on the "Select Group Members" page and complete the wizard. Then run consistency check on the SharePoint farm."

The Error details are:

"DPM could not enumerate SQL Server instances using Windows Management Instrumentation on the protected computer."

Recommended Action:

"Please make sure that Windows Management Instrumentation for SQL server is in a good state."

The actual links don't lead anywhere and Google has given me some good articles to try but nothing solid.

The MS links don't work re: the autoprotectinstances.ps1 script you can run to try and re-protect the database but doesn't work.
Also tried all sorts of WMI tests from the DPM server to SQL and vice versa.

I've tried removing the agent and re-installing it.

Funnily enough, rebooting the server works for 1 night, and then fails again the next day.

Any help or advice would be greatly appreciated.

Thanks all! ]]> SQL Server 2008 / R2 jjbeeuk http://www.petri.co.il/forums/showthread.php?t=63419 http://www.petri.co.il/forums/showthread.php?t=63107&goto=newpost Sat, 06 Apr 2013 14:27:26 GMT My setup is this:

Primary SQL server at headquarters

5 Secondaries located around the country at our satellite offices.

I perform synchronizations over the WAN with very little bandwidth, we're talking fractional T1.

I've had some failures of my sync job, but when I added several seconds for network and general timeout to the connection string for the job, it seems to have fixed itself.

Is that normal practice? What do you suggest? ]]> SQL Server 2008 / R2 beer http://www.petri.co.il/forums/showthread.php?t=63107 http://www.petri.co.il/forums/showthread.php?t=62984&goto=newpost Thu, 21 Mar 2013 14:52:49 GMT Hi, folks I have a serious problem with a SQL installation which is part of an application installation. The installation is on a Windows 2008 server which is a member server on a domain. I am unable to use the application because it has been unable to update an existing installation of SQL... Hi, folks

I have a serious problem with a SQL installation which is part of an application installation. The installation is on a Windows 2008 server which is a member server on a domain.

I am unable to use the application because it has been unable to update an existing installation of SQL Server Express 2005 with SQL Server Express 2008 SP1.

I am unable to uninstall SQL Exp 2008 SP1 and need to do so in order to re-install the application and get it working. I am not concerned about keeping the existing instance.

Note that I know very little about SQL.

History:
We use CA Arcserve V12 and Arcserve V12 used SQL 2005 Express to manage its database.

Just under two weeks ago I upgraded Arcserve to r16. During the installation it tried to upgrade SQL 2005 Exp to SQL 2008 Exp SP1. During the upgrade it reported an upgrade failure with the message that the path could not be found.

Setup continued, but because the SQL upgrade had failed, Arcserve reported encryption errors and, as expected, the database engine could not be started.

I have spent over a week with Arcserve's technical support with this and they just keep taking me round in circles - run the SQL Express 2008 uninstaller from Control Panel, if it fails reboot the machine, run the uninstaller, if it fails reboot the machine and on and on.

I posted on CA's forums and the guys there recommended a complete uninstall and reinstall. I have uninstalled Arcserve which was successful but when I tried to uninstall SQL I got the same path not found error.

I posted in Microsoft's SQL forums and received some help there from a guy who referred me to a thread recommending that certain registry keys be deleted and SQL folders on the computer be renamed. I did this, rebooted the server and tried to install SQL Server 2008 Express SP1 on its own. This failed with the same error message but this time a comprehensive report had been generated that detailed the installation steps and problems. I have uploaded the report and am hoping the guy on the MS forums who has been helping me will be able to determine the problem so it can be fixed.

This was two days ago.

What I'd like to know is, is there anyone who has run into this problem before. Were you able to solve it?

I am not worried about keeping the existing instance as all the info can be retrieved from the backup tapes once Arcserve has successfully installed.

I have contacted a local IT consultancy but they don't have anyone who will be able to take it any further than I have done thus far. They said that the best option may be to open a support ticket with Microsoft.

This is obviously an option but if it can be resolved with a little help from the forums that would be great.

Any suggestions, please?

Thanks! ]]> SQL Server 2008 / R2 Blood http://www.petri.co.il/forums/showthread.php?t=62984 http://www.petri.co.il/forums/showthread.php?t=62820&goto=newpost Thu, 28 Feb 2013 04:42:06 GMT Hi,

Does MS SQL "Runtime" 2008 std edition requires a product Key for activation?

Regards,
Anish ]]> SQL Server 2008 / R2 Anishk http://www.petri.co.il/forums/showthread.php?t=62820 http://www.petri.co.il/forums/showthread.php?t=62758&goto=newpost Thu, 21 Feb 2013 17:03:56 GMT I install SQL Express 2008 R2 on local (app) server 2008.
Installing as domain admin. Now have to add user for SQL admin
Sure don't want that current user will be in SQL Administrator.

Would it be OK to add server local admin to SQL administrators?

What is the best practice?

Thanks,
Michael. ]]> SQL Server 2008 / R2 mla http://www.petri.co.il/forums/showthread.php?t=62758 http://www.petri.co.il/forums/showthread.php?t=62689&goto=newpost Wed, 13 Feb 2013 13:49:34 GMT HI Everyone,

I'm performing an upgrade from SQL Server Express 2008 R2 SP2 to SQL Server 2012 standard. I'm doing this all in a test environment before I do it live. Here's my issue:

I was successful upgrading from SQL Express 2008 R2 SP1 to SP2

I then tried to install the SQL 2012 Upgrade advisor but it told me to install scriptdom during the installation.

I did that and then the upgrade advisor for SQL 2012 did install successfully.

I then ran the Upgrade advisor and after it finished it gave me an an error in the Upgrade Advisor report. Here's the error:

The best practice group returned null result

DPVSWITHDATETIME

I can't seem to find anything about this on the Internet at this time.

Here's my environment and all the software are downloaded trial versions

Windows 7 Enterprise

SQl Express 2008 R2

SQl 2008 R2 SP2

Sql 2012 standard

Any help would be appreciated. ]]> SQL Server 2008 / R2 Steveaxt http://www.petri.co.il/forums/showthread.php?t=62689 http://www.petri.co.il/forums/showthread.php?t=62563&goto=newpost Tue, 29 Jan 2013 10:33:02 GMT Hi I see SQL 2012 express has a db size limit of 10gb, is this limit for each database on the instance, or the total size of all databases on the instance. For example, can I have 4 databases each 6gb in size on a single instance. Regards Mark Hi

I see SQL 2012 express has a db size limit of 10gb, is this limit for each database on the instance, or the total size of all databases on the instance.

For example, can I have 4 databases each 6gb in size on a single instance.

Regards
Mark ]]> SQL Server 2008 / R2 MarkJones http://www.petri.co.il/forums/showthread.php?t=62563