- run
SQL Management Studio
SQL Server Agent
- Jobs
- LSRestore_MAIN_DB_SERVER_YOUR_DATABASE_NAME
- right click - Disable
- get database files settings
select * from YOUR_DATABASE_NAME.sys.database_files
GO
ALTER DATABASE YOUR_DATABASE_NAME SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
xcopy /F D:\sqldb\YOUR_DATABASE_NAME.mdf E:\
xcopy /F D:\sqllog\YOUR_DATABASE_NAME_log.ldf E:\
- change database files settings
ALTER DATABASE YOUR_DATABASE_NAME
MODIFY FILE (
NAME = 'YOUR_DATABASE_NAME',
FILENAME = 'E:\YOUR_DATABASE_NAME.mdf'
)
GO
ALTER DATABASE YOUR_DATABASE_NAME
MODIFY FILE (
NAME = 'YOUR_DATABASE_NAME_log',
FILENAME = 'E:\YOUR_DATABASE_NAME_log.ldf'
)
GO
- switch database online (
SQL Management Studio
- Databases
- YOUR_DATABASE_NAME
- right click - Tasks
- Bring online
)
SQL Server Agent
- Jobs
- LSRestore_MAIN_DB_SERVER_YOUR_DATABASE_NAME
- right click - Enable
SQL Server Agent
- Jobs
- LSRestore_MAIN_DB_SERVER_YOUR_DATABASE_NAME
- right click - Start Job At Step...
SQL Server Agent
- Jobs
- LSRestore_MAIN_DB_SERVER_YOUR_DATABASE_NAME
- right click - View History
- check on errors