I ran the attached script & it created transaction logs of 80GB+ & then stopped with the message
below due to shortage of disk space for the transaction logs:
The transaction log for database 'SSM' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Msg 9002, Level 17, State 4, Server SPPAAH, Line 1
The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
I have another local drive with 110GB plus the current drive with 80GB that houses the current
transaction log. Can anymore suggest how I can go about doing this?
Possible to amend the attached SQL script so that it doesn't generate such a huge transaction log
or it writes to both the drives to split up transaction logs or ... ?