ejbatu1 (8/9/2010)

---

I had another question on this... is backing up the log file (overwrite mode) every two hours and backing up the DB once a day (at night) a good...

I'm a little late to this thread, but since this is live data, you should back up the table first so you can recover in case something goes wrong. If...

I think he's...

Why ? You will miss out on many 2005 benefits.

OP: This has been covered many times. Search...

There were 12 rows that were flagged as having bad data :

Agent

--------

BA BR 1

BA BR 1

33 1U 1

1V 0B :

D2 HB 1

BU GB ...

I'm a SSIS newbie, so it took some poking around, but I was able to find the "Redirect Row" function within the error output feature. This gave me 12 bad...

Did the schedules within the job get disabled somehow ?

quackhandle1975 (7/12/2010)

---

Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod...

y.koteswarrao-652921 (7/7/2010)

---

Hi,

thanks for your suggestions...i able to restore further txn logs after stopat as per your suggestions , but my purpose was not met...

From the restore Txnlog_2 with stopat i...

Did you take a full backup of the database first ?

Are you working with SQL Logins or Windows accounts ?

For Windows accounts, I create Active Directory Groups, such as "DatabaseA_ReadWrite", then put Windows accounts such as MyDomain\MikeSmith into that group....

Thanks a lot for the feedback !

If you are not familiar enough with coding it in T-SQL, you can use the GUI to setup the restore and select all the files & locations. Before hitting the...

Is the database in "full" recovery, but you are not taking frequent trans log backups ?

I just deleted a Maint Plan and it deleted the job automatically.

(SQL 2005 SP3)