-
Notifications
You must be signed in to change notification settings - Fork 299
Open
Description
🐛 Bug Report
The intent to use CSET in macOS or Linux did not work.
There is an issue with restoredb.sql and names mismatch in some files related to database.
To Reproduce
After repo was copied and docker was composed the following step failed.
make create-bak && make load-bak
Output
% make create-bak && make load-bak
# cat backup/bak-files/CSETWeb.bak.part_* > backup/CSETWeb.bak
# docker exec -i cset-mssql /opt/mssql-tools/bin/sqlcmd \
# -U 'sa' \
# -P "Password123" \
# -i /var/opt/mssql/backup/restoredb.sql
# Error response from daemon: Container 63e6f3c542adee6f85b0686346fd970e40e1dfe84be68a99cca83d789101e710 # is restarting, wait until the container is running
# make: *** [load-bak] Error 1
When checking restoredb.sql it was identified a mismatch on database name, but it seems that mismatch persist in other files
# restoredb.sql
ALTER DATABASE CSETWebTest #name mismatch
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE CSETWebTest
FROM DISK = '/var/opt/mssql/backup/CSETWebTest.bak' #name mismatch
WITH REPLACE,
MOVE 'CSETWebTest' TO '/var/opt/mssql/data/CSETWebTest.mdf', #name mismatch
MOVE 'CSETWebTest_Log' TO '/var/opt/mssql/data/CSETWebTest_Log.ldf' #name mismatch
GO
within folder backup only exists CSETWeb.bak
Metadata
Metadata
Assignees
Labels
No labels