I've got one restore to do, but this .bak as 4 datafiles that are using 358GB, the point is that i've got no space in one of the drives because
one of the log files have 85GB. I can't resize the TLogs if i'm using grafic tool to restore the database.
Is there any possibility to make changes in the script that is generated in the grafic tool to make that modification in the log file?
RESTORE DATABASE [DBNAME] FROM DISK = N'S:\DBNAME_db_200810160046.BAK' WITH FILE = 1,
MOVE N'FN_Data' TO N'E:\SQL_DATA\DBNAME.mdf',
MOVE N'FNVE_Data_2' TO N'F:\SQL_DATA\DBNAME_1.NDF',
MOVE N'FNVE_Log' TO N'F:\SQL_DATA\DBNAME_2.ldf',
MOVE N'FNVE_Log2' TO N'F:\SQL_DATA\DBNAME_3.LDF', NOUNLOAD, STATS = 10
Thanks and regards,