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 |
|
kweegly
Starting Member
7 Posts |
 Posted - 2010-01-13 : 06:08:23
|
| Hi,I am trying to backup my SQL databse using SQL Management studio 2005, the issue I am having is that the option to backup to disk is greyed out and only tape appears.Does anyone know why this would happen? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-13 : 06:41:58
|
| Have you tried "backup database my_db to disk='<my_backup_path\my_db.bak'> ?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
kweegly
Starting Member
7 Posts |
Posted - 2010-01-13 : 06:53:05
|
| I resolved the problem, by unistalling the management studio and the disk option was no longer greyed out. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-13 : 06:55:41
|
| Did you then reinstall it?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
kweegly
Starting Member
7 Posts |
Posted - 2010-01-13 : 07:02:02
|
| Yes sorry, I reinstalled the management studio. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-01-13 : 07:12:14
|
| Thanks - had there previously been a tape drive backup ?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
kweegly
Starting Member
7 Posts |
Posted - 2010-01-13 : 07:13:43
|
| No never used tape, I just went to backup as normal and the only option was tape, after the reinstall tape was greyed out again and disk was now available. |
|
|
|
|
|
|
SQL Backup