Our Windows server is having issues but before running disk repair, I want to take a backup. At the moment I'm using SystemRescure (the Linux utility) and I have successfully saved files.
The only problem I have is that I need to take a backup of MSSQL databases. Now for obvious reasons I can't use SSMS software nor command line to get it because MSSQL is not running and it can't be started since I'm on Linux just browsing the hard disk.
What options do I have? I was thinking of saving all database files (tables, indexes ecc.) but:
- I have no idea where MSSQL stores them
- I suspect that I can't do anything with such files. I mean probably I can't magically import them on a new server