Automatic backups for production databases without taking SQL server offline
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

Best way to back up SQL Server 2008 database?
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

sql server 2008 backup and restore
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