Swappping DB with same name

kevin janssens 21 Reputation points
2021-10-04T16:55:19.053+00:00

I install Lenel acces control software, the db is always the same name "Accesscontrol". i always take a copy with me after an install or upgrade.

My question is:

What would be best practice to load this AccesControll db in my sqlserver at home if i plan on loading in a different customer on daily basis.

Only 1 db needs to function at the same time, its always a default instanced.

Ty in Advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
450 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-10-05T02:31:01.893+00:00

    Hi kevinjanssens-8349,

    Welcome to Microsoft Q&A.
    You can take the backup for database, and restore them in sequence in your SQL Server at home. Please make sure full database backup or differential database backup must be restored first with NORECOVERY, and restore log backups in chronological order with NORECOVERY, restore the last log backup with RECOVERY.
    Please refer to Create a Full Database Backup and Restore a Database Backup which might be helpful.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2021-10-04T21:53:18.03+00:00 
    RESTORE DATABASE accesscontrol FROM DISK '<pathtobackup>' WITH REPLACE
    0 comments
  2. Limitless Technology 39,351 Reputation points
    2021-10-05T07:55:26.057+00:00

    Hello Kevin J,

    Maybe it would be a good idea to post your question in the forums of the software manufacturer as their community may be better equipped and understand the settings and requirements of the tool.

    From my standpoint, in order to not alter the DB and the potential consequences, I would just keep a folder structure with each of customers for their DBs and backups.

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments