Bookmark and Share
Last Updates
Display: 11 - 20 of 150, Total Pages: 15
<< < 1 2 3 4 5 6 7 8 ... 15 > >>
[Work Notes] Backup tips [Original] 2014-5-28 11:28am
· --  Review databases and their state SELECT database_id, name, state_desc FROM sys.databases; Go · --  Review files that are used by a dev DB USE wwdev01 go SELEC..

Read Full Article...

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

[Work Notes] Set recovery model [Original] 2014-5-23 1:50pm
·         Set recovery model ALTER DATABASE Market SET RECOVERY SIMPLE; GO ALTER DATABASE Market SET RECOVERY FULL; GO ·   ..

Read Full Article...

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

[Work Notes] Check reasons of Inability to Truncate a Log [Original] 2014-5-23 1:37pm
-- Check size for a DB and LOGSELECT name AS Name,     size * 8 / 1024. as SizeinMB,    FILEPROPERTY(name, 'SpaceUsed') * 8 /1024. as SpaceUsedInMB,    CAS..

Read Full Article...

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

[Work Notes] Check backup history [Original] 2014-5-21 5:17pm
-- Check backup historyUSE msdb;GOSELECT    bs.media_set_id,    bs.backup_finish_date,    bs.backup_size,    bs.compressed_backup_size, ..

Read Full Article...

Section:MS SQL Server DBA | Read:517 | 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:452 | Comment:0 | Rating:0%

[Work Notes] DBA tips: check size, log full, etc [Original] 2014-5-21 5:08pm
==check all databases' log file sizesDBCC SQLPERF(LOGSPACE);GO==check a table sizeUSE mbprod2;GOEXEC sp_spaceused N'dbo.htf43t_onstand_status';GO==check a database sizeUSE dbprod;GOEXEC sp_spaceused @..

Read Full Article...

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

[Work Notes] User accounts admin useful commands [Original] 2014-5-21 11:33am
Query the list of existing logins SELECT * FROM sys.server_principals where type IN ('S','U','G'); GO CREATE LOGIN HRApp WITH PASSWORD = 'Pa$$w0rd', CHECK POLICY = OFF; GO SELECT * FROM sys.sq..

Read Full Article...

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

[Blog] How does "LOAD DATA LOCAL INFILE" work? [Original] 2012-9-6 12:46pm

How does "load data infile" work in different binlog_format?

Read Full Article...

Section:MySQL DBA | Read:1206 | Comment:0 | Rating:0%

<< < 1 2 3 4 5 6 7 8 ... 15 > >>
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