How to keep one more backup copy of current database.
-
How to keep one more backup copy of current database.. where i am using only single database to keep my 10000 record of info. if something goes wrong what to do...So i want to keep one more copy of that keeps continues changes info of main database.. ************ S G KORE *******************
-
How to keep one more backup copy of current database.. where i am using only single database to keep my 10000 record of info. if something goes wrong what to do...So i want to keep one more copy of that keeps continues changes info of main database.. ************ S G KORE *******************
No don't keep a copy of the database keep a BACKUP of the database. If you are using 2008 you can get compression with the backup and keep multiple versions. A typical backup regime is something like backup every night mon-fri keep the last 5 fri backups backup end of month regardless of the DOW and keep for 12 months keep the EOQtr indefinately
Never underestimate the power of human stupidity RAH
-
How to keep one more backup copy of current database.. where i am using only single database to keep my 10000 record of info. if something goes wrong what to do...So i want to keep one more copy of that keeps continues changes info of main database.. ************ S G KORE *******************
Look into replication (publication) or log shipping. Depending on your usage and resources the type you use may very. You can replicate to the same SQL server.