I am very new to being a Database admin, so please bear with me. :-)
I am looking into doing a backup/restore method in replacing my current MS SQL Server 2005 system.
Will using the backup/restore method carry over any necessary NTFS permissions? Is this something that I even need to worry about?
I am transferring over the shares from the old SQL server to the new, but I'm curious how the database files will be affected.