General information
Forum:
Microsoft SQL Server
Mike, your advice was 100% perfect. Running sp_help_revdatase made all the difference. I successfully copied all the data from the production server to the development server. Now I'm confident that if we lose that server, we can bring the other one online as a temporary replacement.
I use VFP as my front end. It runs a little app on the file server that checks to see if the DSN is correct and modifies it if neccessary. I can change the server name and IP address specified in that app, and the user's application will connect to the other server.
Our databases are tiny. The backup takes 2 minutes to run a log backup, and 30 minutes to run a full backup. I'm thinking about setting up the schedule to do a full backup every night and 4 log backups during the day. Does that sound reasonable to you?
Thanks again,
Ross
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only