Diverse

Re: sql dump

xmldeveloper — Tue, 05 May 2009 10:20:54 GMT

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.

Re: sql dump

Diana — Thu, 16 Apr 2009 10:56:36 GMT

E deja "discontinued" in SQL 2008:

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

Re: sql dump

ggciubuc — Thu, 16 Apr 2009 10:44:39 GMT

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

Re: sql dump

Diana — Thu, 16 Apr 2009 10:04:08 GMT

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...)

sql dump

ungureandavid — Thu, 16 Apr 2009 08:06:12 GMT

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