Dear John,

Yes it...

Dear all,

I made it like this :

--CREATE PROCEDURE SP_TRUNC_INS_M_SUPP

--AS

declare @pre_var INT

DECLARE @SSQL SQL_VARIANT

DECLARE @SQL SQL_VARIANT

---TRUNCATE THE TABLE ( empty the data )

IF EXISTS (SELECT * FROM SYS.OBJECTS WHERE [NAME]...

your welcome and thanks for visiting

your welcome and thanks for visiting

it comes with error:

(3 row(s) affected)

(26 row(s) affected)

Msg 8134, Level 16, State 1, Line 59

Divide by zero error encountered.

Jeff Moden (11/2/2016)

---

Deny Christian (11/1/2016)

---

else,

i used this syntax

DECLARE @CMD sysname

--create .bat:

/*.bat:

@echo off

forfiles /p "d:\backup\bck_denyc\combine" /m *.bak /c "cmd /c del /Q @file" /d -30 --to delete 30 days back

@echo...

FridayNightGiant (11/2/2016)

---

You haven't provided enough information to help. How are you determining the number of rows in the oracle table? What process are you using to move rows. Does the...

else,

i used this syntax

DECLARE @CMD sysname

--create .bat:

/*.bat:

@echo off

forfiles /p "d:\backup\bck_denyc\combine" /m *.bak /c "cmd /c del /Q @file" /d -30 --to delete 30 days back

@echo off

*/

--execute the .bat:

exec @cmd...

Hi,

I already made Policy about Backup and Restore Database. and it is very Detail, Including steps,guidance,and SOP. All with the screen capture and insert it as attachment at the policy.

Now...

Grant Fritchey (10/20/2016)

---

Sorry, I don't see anything. What are you attempting to do? Describe your backup plan and how it meets your Recovery Point Objective and Recovery Time Objective worked...

Grant Fritchey (10/19/2016)

---

Jeff Moden (10/19/2016)

---

Deny Christian (10/18/2016)

---

Jeff Moden (10/18/2016)

---

FROM DATABASE...

Jeff Moden (10/19/2016)

---

Deny Christian (10/18/2016)

---

Jeff Moden (10/18/2016)

---

FROM DATABASE is typically...

Jeff Moden (10/18/2016)

---

FROM DATABASE is typically used only when you...

I still confuse about Restoring:

Specify the source and location of backup sets to restore:

from database

from device

what's the different ?