Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resize TLog when restoring database... Expand / Collapse
Author
Message
Posted Thursday, October 16, 2008 10:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 12:57 PM
Points: 186, Visits: 805
Hello,

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
GO

Thanks and regards,
JMSM ;)
Post #587143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse