SQL Server backup and restore failed

Error One:

Backup failed for server "xxxxxx".

System.Data.SqlClient.SqlError: Unable to use backup file ' C:\Program Files\Microsoft SQL Server\mssql11. Mssqlserver\mssql\backup\xxxxx.bak ' because the sector size used to format the file was 512, and the current device's sector size is 4096. (MICROSOFT.SQLSERVER.SMO)

Reference: Http://stackoverflow.com/questions/24285195/sql-server-2012-express-backup-database-failure

Method:

Delete the current path and add a new backup file to the backup folder in the SQL Server directory. Note that you should remember to add. bak or. trn after the file name.

Error Two:

Database restore failed.

System.Data.SqlClient.SqlError: Unable to execute backup LOG because there is currently no database backup.

　　　　

Method:

In the interface with the database, there is an Options page, click Options.

Tick-Overwrite existing database

Uncheck--end-of-log backup before restore

SQL Server backup and restore failed