Salut.

Stie careva care este sintaxa pentru dump in sql server. Lucrez la un program care sa faca dump automat, la un anumit timp.

Intrebarea mea este cum sa obtin fisierul *.bak cu baza mea de date

Am incercat asa:

dump database cvpc
    to "c:\cvpc.bak"

si nu merge, imi da eroarea asta

Msg 3206, Level 16, State 1, Line 1
No entry in sysdevices for backup device 'c:\1.bak'. Update sysdevices and rerun statement.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

multumesc!

dav

Cauta "BACKUP" in Books Online.

De exemplu, pentru SQL 2008:

http://msdn.microsoft.com/en-us/library/ms186865.aspx.

Atentie la detalii (modelul de recovery al bazei,  tipul de backup, optiuni...)

Dump vine de la batranul Sybase care, asa cum scrie in Books Online , "The DUMP statement is included for backward compatibility. This feature will be removed in a future version of Microsoft SQL Server" , asa ca mai bine orientati-va spre ce a mentionat Diana

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)

E deja "discontinued" in SQL 2008:

http://msdn.microsoft.com/en-us/library/ms144262.aspx

Daca va uitati un pic la mesajul de eroare va si sugereaza metoda recomandata:

Msg 3206, Level 16, State 1, Line 1
No entry in sysdevices for backup device 'c:\1.bak'. Update sysdevices and rerun statement.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro