Hello,
I am thinking to restore the database into Sql Server using same backup for existing Database with REPLACE option, Do I need enough space or it will overwrite so I don't have to worry for disk space?
USE master;
GO
ALTER DATABASE SqlTEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
RESTORE DATABASE SqlTEST
FROM
disk = 'd:\mssql\backup\SqlTest.bak',
WITH REPLACE
,RECOVERY
,NOUNLOAD
,REPLACE
,STATS = 10;
GO
My current DB backup size close to 1 TB and I have currently disk space shows free is around 250 GB but when I restore it with REPLACE, it will throw an error for not enough disk space or overwrite (REPLACE) option will take care off it?
Thanks for your assistance!