Activity overview
Latest activity by Joppe
To add on to this the solution we had to use was to shut off the service of the SQL Agent on the instance where it had created a clone to bypass the windows error that the file was being used. / comments
To add on to this the solution we had to use was to shut off the service of the SQL Agent on the instance where it had created a clone to bypass the windows error that the file was being used.
SQL Clone "attaching" the clone
I would like to have the agent run a script that after cloning, it detaches the database and then attaches it again with some modifications. As of now this is not possible as the agent tries to att...
Cloning a SQL Server database with a FILESTREAM
We have a
database with a FILESTREAM. For a FILESTREAM the DIRECTORY_NAME property must
be unique within an SQL instance. If we try to clone an image on the same SQL
instance as the original databa...