Skip to main content

Notifications

Microsoft Dynamics RMS forum

RMS & Sql Server 2008 Database Restore Issue

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

  • Verified answer
    Derek McGrath Profile Picture
    Derek McGrath 465 on at
    RE: RMS & Sql Server 2008 Database Restore Issue

    Hi,

    Thanks for your advice.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: RMS & Sql Server 2008 Database Restore Issue

    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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans