Backups before Close
Backups before Close
(OP)
The move to Progression on MS SQL Server was uneventful...but I am unsure how to do backups before I close, purge, etc. I know I can't copy and paste to a folder on my PC instead I have to go through the SQL Server Management Studio. In reading on this is sounds like a copy only backup should work.
Please share how you backup prior to closing, doing purges, etc.
Thanks
Please share how you backup prior to closing, doing purges, etc.
Thanks
RE: Backups before Close
You are correct....you cannot just copy a folder of files as a database backup with SQL as you could with Pervasive.
I always do a full database backup from SQL Server Management Studio prior to any major posting/closing event. You can always restore from that backup file in case something goes wrong.
Also, one other quick note....hopefully, when you made the move to SQL Server, you also set up some maintenance activities on your database.... The purpose of these tasks is to ensure the integrity and performance of your database. You can accomplish these tasks by generating a "maintenance plan" or you can generate your own scripts. Personally, I've gone the route of using my own scripts....
Jen
RE: Backups before Close