M
M
Max Trophy2016-04-07 04:01:52
SQL Server
Max Trophy, 2016-04-07 04:01:52

Why can't I backup the database?

fc920d3f11ba4f8ba2626edbc3579b03.jpg
Right-clicking on the database and on the tables will not help, there are no backup buttons at all.
How else can you do it? We need a .bak file
. The screenshot is somehow hard to see, I'll sign it ..

BACKUP DATABASE test2
TO DISK='C:\test2.bak'

MISTAKE:
Важная ошибка 0x80040E14, незначительная ошибка 25501
> BACKUP DATABASE test2
TO DISK='C:\test2.bak'
Ошибка при разборе запроса. [ Token line number = 1,Token line offset = 1,Token in error = BACKUP ]

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
res2001, 2016-04-07
@kapitoly

I have never worked with MS SQL Compact Edition, but judging by a cursory googling on this topic, this version does not support the backup / restore commands - a backup is made by simply copying the database after disconnecting all connections to the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question