web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

RMS & Sql Server 2008 Database Restore Issue

(0) ShareShare
ReportReport
Posted on by 465

Hi There,

 

I have a database about 11 GB in size  that was backed up by RMS SO Manager running on SQL Server 2005 on a SBS 2003 server

When I attempt to restore it through the SO Admin onto my Windows 7 laptop  I get the following message/error

 

"[SQL-DMO]Row or Column specified is outside the range of the specified query set"

In addition i get the following message upon clicking ok

 

"Run Time error - 2147199728(80045510)

[SQL-DMO] The name "xxx" was not found in the database collection. IF the name is a quaified name, use {} to seperate various parts and try again

 

Many Thanks

 

Derek

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    what version of sql are you running on your laptop because to restore a 11gb database you will need the retail version.  

    Also you could try restoring from the SQL Management Studio.  you can download at

    www.microsoft.com/.../details.aspx

    Also it might be a corrupt backup.  try running the backup again and then restore from the new backup if possible.

  • Verified answer
    Derek McGrath Profile Picture
    465 on at

    Hi,

    Thanks for your advice.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans