Ash Ghai
asked on
Error when trying to copy database: Event ID: 12291 Source: SQLISPackage
Trying to use the sql database copy from one server to another
Keep getting this error
Error when trying to copy database: Event ID: 12291 Source: SQLISPackage
SQL 2014 server on both servers
Keep getting this error
Error when trying to copy database: Event ID: 12291 Source: SQLISPackage
SQL 2014 server on both servers
Hi Ash,
Look at the log files in the following location:
%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ER RORLOG
Execute the same with the SA user.
If you don't have a SA user check that the user has the server role sysadmin
let me know if you need more info
regards,
Davy
Look at the log files in the following location:
%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ER
Execute the same with the SA user.
If you don't have a SA user check that the user has the server role sysadmin
let me know if you need more info
regards,
Davy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Could be something as simple as "Access is denied" or "Could not read metadata, possibly due to insufficient access rights." but will definitely be there and tell more than just "Event ID: 12291"