Results 1 to 11 of 11
Thread: , ?
Hybrid View
-
4th January 2006 19:48 #1Registered User
Join Date: Jun:2005
Location: Plovdiv
Posts: 19
, ?
.
Win XP , , .
Windowsa?
SQL Server-a , .
-
4th January 2006 19:57 #2
:)
xcopy /c
Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K
-
4th January 2006 20:35 #3
-
4th January 2006 20:37 #4
Last edited by singularity; 12th April 2007 at 14:09. Reason:
ignore list:Java,velio,jaredharet,gochev.george,Nit rogeniumQuis custodiet ipsos custodes?
-
4th January 2006 20:40 #5
-
4th January 2006 20:52 #6
.
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
4th January 2006 20:56 #7Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K
-
4th January 2006 21:13 #8
-
5th January 2006 00:44 #9Registered User
Join Date: Jun:2005
Location: Plovdiv
Posts: 19
, exit MSSQL Servera, .
Originally Posted by Private
, , , .
-
5th January 2006 11:07 #10mssql (query analyzer -> help -> transaction sql -> backup)Examples
A. Back up the entire MyNwind database
Note The MyNwind database is shown for illustration only.
This example creates a logical backup device in which a full backup of the MyNwind database is placed.
-- Create a logical backup device for the full MyNwind backup.
USE master EXEC sp_addumpdevice 'disk', 'MyNwind_1',
DISK ='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_1
B. Back up the database and log
-- Create the backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_2',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'
--Create the log backup device.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'
-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_2
-- Update activity has occurred since the full database backup.
-- Back up the log of the MyNwind database.
BACKUP LOG MyNwind
TO MyNwindLog1
Last edited by XaMaB; 5th January 2006 at 11:15.
: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()




Reply With Quote

R9 280,
07.05.23 ., 21:28 in