Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
staplebottom
Starting Member
29 Posts |
 Posted - 2007-05-08 : 16:26:42
|
Hi,Ive a few questions on backups im hoping someone can help me with.1. Is it possible to create backups, with the db in a disconnected state, which can be reattached and will function exactly as the database was at the time of the backup?2. In sql express I currently have one backup which is a full backup. I would like to have an other backup on a different disk, but when I add another one in the Destination box I get an error 'The volume of device 'first backup' is not of a multiple famliy media set'. Is it possible to have moree than one backup of the database?3. What are the main things that third party software packages do that the built in backup cannot? What do they make easier?4. If I delete my current backup, and then create a new one, will it include all transactions logs, and have multiple restore points, or will it just create a backup of the current time, with no transaction logs?5. I have found a simple script that allows me to restore my backup to a new database :RESTORE DATABASE test FROM DISK = 'C:\SQL\SQLWLM.BAK' WITH MOVE 'wlm.com' TO 'C:\SQL\test_Data.mdf' , MOVE 'wlm.com_Log' TO 'C:\SQL\test_log.ldf', REPLACE that works in restoring the database to a new database. However, it only restores to the earliest point, rather than the most recent. Can this be fixed easily?Thanks,C |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-09 : 11:21:34
|
| 1. You mean db is offline? You can backup db files with file backup tools.2. Yes, need another backup statement.3. Compressing is one of them.4. Full backup includes logs, but can't do opint of time restore.5. Need apply log backups. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
|
|
Questions on backups