Unable to restore database in SQL Server because of running processes.
If you are unable to restore database in SQL Server because of running processes.
1. You can find which processes are running using the following command:
sp_who2
2. After finding out which processes are running relating to the particular database, you can kill them using the kill command with process id
For eg.
kill 63
kill 55
If you are unable to restore database in SQL Server because of running processes.
1. You can find which processes are running using the following command:
sp_who2
2. After finding out which processes are running relating to the particular database, you can kill them using the kill command with process id
For eg.
kill 63
kill 55
This should restore your database.
No comments:
Post a Comment