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?
Answer Question | August 10, 2010 3:49 PM
Backup, SQL Server, SQL Server 2008, Sql Server 2008 Backup
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?
Answer Question | July 16, 2010 7:50 PM
Shadow Copy, SQL Server 2008, SQL Server 2008 administration, Sql Server 2008 Backup, SQL Server database
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
Answer Question | May 19, 2010 6:46 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore