İptal Edildi

SQL 2005 Backup & Restore procedures

Need two SQL 2005 stored procedures created for database backing up and database restores using the following requirements.

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

DatabaseBackup

@DatabaseName

@BackupType (Full, Log)

@Directory

@Compress (bit=yes/no)

@StoreByWeek (bit=yes/no)

@BackupType=Full

The backup process should first truncate the log.

The backup process should create a backup file in a directory (given by @Directory) name [url removed, login to view]

@BackupType=Log

The backup process should create a Log backup file in a directory (given by @Directory) name DatabaseName & CurrenTime(Format HHmm).Bak

@Compress=1

Run the newly create backup file thru gzip (assume c:[url removed, login to view] is the exe location)

@StoreByWeek=1

“Move” the newly create file to a sub folder that corresponds to the day of the week number

Ex. F:Backup1 OR F:Backup2

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

-----------------------------------------------------

DatabaseRestore

@DatabaseName

@DatabaseCreateDirectory

@BackupFileDirectory

@Decompress (bit=yes/no)

@RestoreLogs (bit=yes/no)

@RestoreStopTime (if null then ignore)

Assume the backup file directory will have file names that are formatted the same as the Database Backup SP

Assume the database is created with statement like this.

CREATE DATABASE TestDB

ON (NAME = TestDB, FILENAME = 'C:[url removed, login to view]')

LOG ON (NAME = TestDB _log, FILENAME = 'C:[url removed, login to view]')

Beceriler: Betik Yükleme

Daha fazlasını görün: databasebackup sql 2005, on sql, stored procedures, sql script , sql c, procedures, null, move sql, gzip, backup database, sql created, sql statement stored, decompress, script gzip, sql create script, amp sql, day number week, given following requirements, mdf sql script, create database stored procedures, file sql bak, process location, filename, amp full name, stored amp sql

İşveren Hakkında:
( 17 değerlendirme ) Dallas, United States

Proje NO: #205941

3 freelancer bu iş için ortalamada 100$ teklif veriyor

momleetech

we can do it

in 5 gün içinde100$ USD
(19 Değerlendirme)
5.2
ropez

I have all needed knowlege to complete this task.

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
pbarbas

Expert, see PM please.

in 4 gün içinde100$ USD
(0 Değerlendirme)
0.0