Hello,

OUTPUT INSERTED.YourIdentityColumn, INSERTED.easilyPatId

My identy colunm is tel_id but for the second output is INSERTED.@easilyPadId (value get from cursor). Is it correct ?

Thanks

Eric

Hi,

I had a row "seen" but I got a error during Insert : The name or the number of column of the supplied values does not correspond to the definition...

Hello,

I have some questions about your script.

I would like to restore all databases from my SLQ 2008 R2 server to a new server (no user databases on it).

If I use...

Solution :

- Disable indexing on FILESTREAM volumes.

- Disable generation of 8.3 names on all NTFS volumes used for FILESTREAM data storage by running the below command at a command...

I found the solution to resolve my issue 😛

I executed the following step :

- Disable indexing on FILESTREAM volumes.

- Disable generation of 8.3 names on all NTFS volumes used...

Another thing, after to implement this solution, I have to run a full backup because if I don't do that my diff backup doesn't work. Is it correct ?

Thanks,

Eric

Ok.

Could I have a performance issues if I implement this solution ?

Thanks,

Eric

Which kind of error I can get ? :crying:

But the main file can't grow up . Is it correct ?

Thanks,

Eric

Do you hold filestream on a specific disk (means one disk for MDF, one disk for LDF, one Disk for file stream) ?

Did you check the fragmentation of filestream's volume...

So you have a database include filestream and the size is 12 Go for *mdf and filesstream. Is it correct ?

Where is it localise ypur filestream ?

Do you have 12Go for filestream and database or only for filestream ?

Thanks for all 😀

Eric

Thanks I solved my issue.

Could you explain me how to determine if the number of VLFS is too high ?