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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / You can not restore th...
Microsoft Dynamics GP (Archived)

You can not restore the company because you and other user are logged in Dynamics GP

(0) ShareShare
ReportReport
Posted on by GovindDevda 617

Hi All,

When i was restore the GP backup file into our Company its says "You can not restore the company because you and other user are logged in Dynamics GP".

But i have already check that no user is login only me "sa"  user login and also fire below query into SQL 

use DYNAMICS 

Delete SY00800
Delete SY00801
Delete ACTIVITY

but not solve my problem.

FYI i am trying to restore backup with "Sa" user in Dynamics GP 2015 (R2)

So please help me out how can solve this problem.

 

Thanks & Regards,

Govind Devda

*This post is locked for comments

I have the same question (0)
  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    Are you trying to restore database from GP?

    Better use SSMS to restore database with single user mode.

    Closer all query window and execute the below query.

    ALTER DATABASE TWO SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    GO

    RESTORE DATABASE TWO FROM DISK = 'D:\TWO.BAK'

    GO

    Hope this helps!!!

  • Verified answer
    GovindDevda Profile Picture
    GovindDevda 617 on at

    Thank you so much Soma,

    i appreciate your knowledge :)

    Regards,

    Govind Devda

  • soma Profile Picture
    soma 24,410 on at

    You are most welcome.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#2
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans