ldf | Lightweight Dynamic Framework for making Single Page | Frontend Framework library

I get a conflict between my two tables. This is the message.

I am looping to load multiple xlsx files. This I am doing well. But when I want to add the name of the columns of the documents (the same names for all files) I have not managed to do it.

I inherited a database, there is no backup.

This database was created on SQL Server 2017 (v14) and the server is no longer available.

I have the .MDF, .LDF and the filestream.hdr files.

Now I want to attach this database to SQL Server 2017.

As you guess it, the attached process fails.

If I try to attached from Management Studio, I get an error that the file stream folder cannot be located.

However, if I point to the folder in script, I get File Activation Error.

There are two folders in the MyDB_Filestream folder but both are empty. $FSGC and $FSLOG

What am I missing?

Syncing a windows app with a linux website, I use a bash script which transfers each day a MS-SQL database from a Windows machine to a Linux installation, and uploads it to the mssql-server with the code below:

I have been trying to run the my docker-compose.yml file for 2-3 days and have spent so much time finding the fix on internet but nothing seems to be working. The host computer is Windows 10 and Docker computer is Linux.

Created volume using this command: docker volume create --driver local --opt type=none --opt device='C:\Users\Kishan\Desktop\db' --opt o=bind mssqldb

and following is my docker-compose.yml file

Is it possible to use 2 LDF in the same CANoe configuration ?

Right now when I try to add the second LDF I get this error message:

Every week I have to restore 2 different databases. I submit a ticket to Epi support and they give me .BAK files with different dates appended to them.

Running SQL Server 2014 (on remote server), Visual Studio 19 (on local machine), and Integration Service Project.

So far, my SSIS package removes previous .BAK files from SQL Server Backup directory, moves the new ones from my Downloads folder to the SQL Server Backup directory, and deletes one of previously existing backups (I like to delete them because WITH REPLACE does not update the LAST RESTORED DATE and I like to keep those up-to-date).

I would think that I could re-use the filename and the directory from when I move the BAK files with a File System Task in order to generate the RESTORE DATABASE statement, but I am not sure how to pass those fields in SSIS.

Now, I need to EXECUTE SQL TASK to RESTORE DATABASE, but it is hard to execute this in one statement with a dynamic filename.

I have looked at many different articles and tried different things, but none have worked.

The following script is what I want to be able to run, but I get errors even when the filename is hardcoded:

RESTORE DATABASE [Insite.Commerce.horizon.Sandbox] FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\horizon-sandbox-20210412.bak'

The errors that this draws are below:

Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file "d:\sqldata\\Insite.Commerce.horizon.mdf" failed with the operating system error 21(The device is not ready.).

Msg 3156, Level 16, State 3, Line 2 File 'Insite.Commerce.horizon' cannot be restored to 'd:\sqldata\\Insite.Commerce.horizon.mdf'. Use WITH MOVE to identify a valid location for the file.

Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file "l:\sqllogs\\Insite.Commerce.horizon_log.ldf" failed with the operating system error 3(The system cannot find the path specified.).

Msg 3156, Level 16, State 3, Line 2 File 'Insite.Commerce.horizon_log' cannot be restored to 'l:\sqllogs\\Insite.Commerce.horizon_log.ldf'. Use WITH MOVE to identify a valid location for the file.

Msg 3119, Level 16, State 1, Line 2 Problems were identified while planning for the RESTORE statement. Previous messages provide details.

Msg 3013, Level 16, State 1, Line 2 RESTORE DATABASE is terminating abnormally.

I am not sure how to address these errors and/or if they are even relevant because I do not know if I am going about a database restore in SSIS the right way.

Regardless, as of now, I am trying to execute the following SQL statement in SSIS in order to return the SQL statement it generates as a result or variable that can be passed to another SQL statement and then executed. See below:

I can execute the following in SSMS and the database will be fully backed up and restored under a new DB name:

I have many txt files that contain the same type of numerical data in columns separated by ;. But some files have column headers with spaces and some don't (created by different people). Some have extra columns which that I don't want.

e.g. one file might have a header like: