Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

enter image description hereenter image description herehello, i want a back up for my database in sql server management studio. i am using ms sql. but when i try to back up , i take the following error:

===================================

Backup failed for Server 'ERDI-PC\SQLEXPRESS'.  (Microsoft.SqlServer.SmoExtended)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617.0+((KJ_RTM_GDR).110422-1901+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   at Microsoft.SqlServer.Management.SqlManagerUI.BackupPropOptions.OnRunNow(Object sender)

===================================

To accomplish this action, set property Devices. (Microsoft.SqlServer.SmoExtended)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617.0+((KJ_RTM_GDR).110422-1901+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyNotSetExceptionText&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Backup.Script(Server targetServer)
   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)

and its image:

Its destination comes as tape not disk. i have controlled whether there is a back up folder or not. but i have realized that i have a back up folder:

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup

i couldn't solve this problem..please help..

share|improve this question

migrated from stackoverflow.com Jul 31 '12 at 14:56

This question came from our site for professional and enthusiast programmers.

    
What type of server you are using i mean to say hosting server.. if its your own local machine then try again. or if you are using some shared hosting then you cannot go for back up as its no provided by those.. –  raman Jul 30 '12 at 11:38
    
You haven't set the "backup to" at the bottom - where do you expect the backup to go? –  Bridge Jul 30 '12 at 11:40

1 Answer 1

up vote 2 down vote accepted
If you want to take backup, another way is that from location
'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data'
you can copy your data base files i.e .mdt and .ldf files
`enter code here`while taking backup make sure that all your sql resources are closed
share|improve this answer
    
it works..thank you very much.. –  rockenpeace Jul 30 '12 at 11:41

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.