|
|
|
Rank: Newbie
Groups: Registered
Joined: 6/17/2012
Posts: 3
|
Hi,
I love this tool and I had successfully tested it for a couple of days. I have LIVE Server and Test Server. Only I have a few questions:
1. During the Backup Schedule, it will make a FULL DB backup which I can restore to my Test Server, now over the next hour it will perform Differential Backup. How can I restore this Differential Backup to my Test Server given that I have loaded the Full DB Backup their?
2. Also, is there a user,password,permission and roles backup that this tool can offer so I can make a backup of my LIVE DB to Test Server?
3. Is there an Incremental Backup for the Beta version?
Thanks,
John
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi, 1. The software makes standard backups with t-sql commands. So, you can use MS tools to restore databases. Please find instructions at: http://msdn.microsoft.com/en-us/library/ms175510.aspx or http://msdn.microsoft.com/en-us/library/ms178105(v=sql.105).aspx2. Yes. 3. Please provide more details about the question.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 937
|
Hi,
On item 2, how can I backup and restore users,roles,password and permnission from Live Server to a Test Server?
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi,
Perhaps I misunderstood your question... If you want to backup and restore users, roles, passwords and permissions ONLY, SQLBackupAndFTP does not have this possibility.
|
|
|
|
|
