Bookmark and Share
Last Updates
Display: 1 - 3 of 3, Total Pages: 1
1
[Work Notes] restore a DB STOPAT Option [Original] 2014-5-29 11:42am
Restore a db by following the following restore sequence:RESTORE DATABASE database_name FROM full_backupWITH NORECOVERY;RESTORE DATABASE database_name FROM differential_backupWITH NORECOVERY;RESTORE L..

Read Full Article...

Section:MS SQL Server DBA | Read:463 | Comment:0 | Rating:0%

[Work Notes] Recovering an offline database step by step [Original] 2014-5-28 4:57pm
Recovering an offline database step by step-- check the database state to see RECOVERY_PENDING;    SELECT name, state_desc     FROM sys.databases WHERE name='Marketdev';&..

Read Full Article...

Section:MS SQL Server DBA | Read:478 | Comment:0 | Rating:0%

[Work Notes] Restore a SQL server DB by using command lines [Original] 2014-5-21 5:12pm
USE master;GOIF EXIST (SELECT 1 FROM sys.databases WHERE name = 'N'Market')    DROP DATABASE Market;GORESTORE DATABASE MarketFROM DISK = 'D:\...\Market.mdf',WITH MOVE 'MarketDev' TO 'D:..

Read Full Article...

Section:MS SQL Server DBA | Read:434 | Comment:0 | Rating:0%

1
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am