July 17, 2009 at 7:29 am
I want to make a copy of a database at the end of every month. I have two t-questions:
1) Are all user logins/permissions copied from the source database to the target. If not, how can I accomplish this.
2) How can I determine which folder the source database is located in, so that I can place the copy in the same folder?
July 17, 2009 at 8:33 am
1. Users and permissions are in the backup, but NOT logins, logins only exist in master, the copy may or may not need all of this depending on how the copy is used. If it is just for a month end copy then you should be just fine..
2. You can read the "table" dbo.sysfiles in the database. I would NOT store the copy in the same place as the original. You could store all the backups together.
I think you might be mixing terms.
A backup of a database is a copy of the entire database that can be restored, this is used for disaster recovery, it contains everything in the database, tables, sprocs, views, data, permissions, everything. However a copy of the database would likely be a database that was restored from a backup, either locally on the same server, or on another server.
Is all this clear?
CEWII
July 17, 2009 at 8:43 am
Thanks for the reply!
By copy I mean a restore of a backup taken on the original. I understand the difference between a backup file on disk/tape and a database that has been restored using that backup file.
Having thought about it a bit more, I agree that it would be better to store the copies in a seperate folder.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply