Viewing 8 posts - 1 through 8 (of 8 total)
Thanks Dird you helped me a lot.
Can I get your contact info in case I need your professional services?
June 16, 2013 at 6:50 am
Dird (6/16/2013)
drnorbert (6/16/2013)
BACKUP DATABASE ISMDATA TO DISK='C:\ISMBACKUP\db.bak'Is this means that the log is backup together with each execution or is a different command for the transaction log every 15 min?
I...
June 16, 2013 at 6:41 am
Hi Dird
I am trying to figure out how you are attaching my responses with your reply massages as well as the images such as:
🙂
Thanks for the details about setting up...
June 16, 2013 at 6:13 am
Dird:
I don't think a remote backup is really required. How many disks does your server have? Assuming there's one spare for backups you could just do this to maximise reliability:
Norbert:
Both...
June 15, 2013 at 7:33 pm
Sorry They are changing/adding 100 records per Hour.
Yes we have 2 servers, can be backup to the other server, also because our experience during this week I would like to...
June 15, 2013 at 4:15 pm
SELECT name
FROM master.sys.databases
WHERE recovery_model_desc != 'SIMPLE'
Results:
model
ReportServer
DATA2007
model
ISMDATA
Users are changing and or adding an average of 100 records. Shall I still backup the log every hour?
June 15, 2013 at 3:44 pm
Great help!
Yes is SQL 2008 (Enterprise Edition).
What about Shrink Database, index, the database gets larger from 300MB to 600MB.
Should I plan to backup the log files every 15 min?
If so...
June 15, 2013 at 12:37 pm
Hi Thanks for your wonderful reply.
I just intalled the programs in just a computer and the same conditions are showing.
As you can suspect I am not to familiar with SQL...
July 22, 2012 at 7:27 pm
Viewing 8 posts - 1 through 8 (of 8 total)