Em Andamento

SQL Server Maintenance Consultation (1 hour)

TASK:

**- every 1 hour

**

1. incremental backups of all databases

2. sql to send email confirmation

**- each night

**

1. full backup db (to local folder on server)

2. full backup db's transaction log (to local folder on server)

3. truncate transaction log (I'm not sure if I need to do this, but websites often display an error saying that's a website's database's transaction log is full) **I need this to stop happening.

**

4. sql to send email confirmation

5. check database integrity (I think this is a built in maintenance feature)

6. re-build indexes (I think this is a built in maintenance feature)

I basically want to 2 "maintenance plans" to schedule as jobs that will follow the best practices listed here:

<[url removed, login to view]>

I will have skype on my machine, you will call me on skype and I will display the server's desktop and you will explain to me how to set this up. This should take about 1 hour.

server: Microsoft SQL Server Web Edition (64-bit)

version: [url removed, login to view] SP1

Habilidades: Vale Tudo

Ver mais: sql server web, night jobs, sql databases, maintenance jobs, library jobs, set bit, consultation jobs, hour jobs, machine jobs, integrity jobs, db transaction, sql microsoft, sp1, microsoft sql website, microsoft sql server, microsoft server, maintenance, hour, hour skype, database microsoft sql, c maintenance, build sql, build database sql, server log, aspx schedule

Acerca do Empregador:
( 74 comentários ) Prague , United States

ID do Projeto: #3040526

Premiar a:

sefbob

See private message.

$34 USD em 17 dias
(1 Comentário)
1.1

6 freelancers estão ofertando em média $34 para este trabalho

robotappsvw

See private message.

$34 USD in 17 dias
(11 Comentários)
3.8
market29

See private message.

$34 USD in 17 dias
(1 Comentário)
3.0
indianasystems

See private message.

$34 USD in 17 dias
(1 Comentário)
1.4
mpesi

See private message.

$34 USD in 17 dias
(0 Comentários)
0.0
frecciavw

See private message.

$34 USD in 17 dias
(0 Comentários)
0.0