question

kevinjanssens-8349 avatar image
0 Votes"
kevinjanssens-8349 asked LimitlessTechnology-2700 answered

Swappping DB with same name

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-generalwindows-server-backup
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog edited

RESTORE DATABASE accesscontrol FROM DISK '<pathtobackup>' WITH REPLACE

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

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--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.