sql server management studio backup error

Question

hello, 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..

Answer 1

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