I need to automatically create backups of my 42 production databases every night without taking my SQL Server 2008 offline. Is this possible? A full backup and transaction backup so I can step back to the exact time I need?

What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command >restore database 'd:nor.bak' it gives me the message as : Incorrect syntax near 'd:nor.bak'. pls let me know how to reatore . Regards, Rino

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy