Ran a query against the database using that script:

BACKUP DATABASE [Resource] TO DISK = N'D:\SQL_Database_Backup\Resource_noinit.bak'

It ran successfully, the bak was created. Any ideas?