| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-01-16 : 02:46:21
|
| I have backups set up on a database and I don't want to cancel the current backups but I want a one time complete backup that I can restore to another machine -- how can i do this? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-16 : 05:12:11
|
| Backup database ... WITH Copy_Only--Gail ShawSQL Server MVP |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-16 : 07:35:18
|
Yes, and the restore should be done using T-SQL because the restore by using the dialog in SSMS will not work.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-16 : 12:21:21
|
| Although I agree that you should use TSQL to restore, the dialog in SSMS will work just fine. Why do you say it will not work?jeff |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-16 : 14:32:34
|
| There's a bug regarding the restore dialog and copy_only backups. Can't remember details or affected versions.--Gail ShawSQL Server MVP |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-17 : 22:04:28
|
| If I remember correctly, the bug is that the copy only backups do not show up in the dialog for restore. I don't think this is a bug myself, but either way - if you select the file you want to restore from it works just fine.Again, I would also recommend using a script to do this - but sometimes using the GUI for one off operations is just easier.Jeff |
|
|
|
abhwhiz
Starting Member
37 Posts |
Posted - 2011-01-19 : 05:03:28
|
| Jeff, you sure abt this? I had tried before and I couldn't see files/file description in the GUI. It didn't let me restore too? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-19 : 21:04:47
|
| Yes - I am sure. I have used the GUI to restore databases from files without any problems. I have restored both backups that were taken with copy only, and without and was able to find the file.If you are trying to find the copy only backup listed in the GUI for a specific database, then it might not show up because it is not part of the normal backup chain. I think this is the 'bug' that everyone is talking about.Jeff |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-20 : 01:15:21
|
No, the 'bug' is (or was) that the restore (via GUI) was terminating with an error (I don't remember the message).
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-20 : 16:29:12
|
| I have never seen that issue - probably because I update my client tools regularly to make sure I get those fixes before I run into these kinds of issues. |
|
|
|
|
take full copy