web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) RMS & Sql Server 2...

Microsoft Dynamics RMS (Archived)

RMS & Sql Server 2008 Database Restore Issue

(0) Share

Report

Report

Posted on by Derek McGrath

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)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Derek McGrath 465 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for your advice.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans