Cancelled

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]')

Skills: Script Install

See more: sql truncate logldf 2005 2000 2008, databasebackup sql 2005, sql 2005 backup process name, sql 2005 backup procedure create name, sql 2005 backup name format, on sql, stored procedures, sql, sql script , sql c, Procedures, null, move sql, gzip, database sql, C# SQL, backup database, sql created, sql statement stored, decompress, script gzip, sql create script, amp sql, day number week, given following requirements

About the Employer:
( 17 reviews ) Dallas, United States

Project ID: #205941

3 freelancers are bidding on average $100 for this job

momleetech

we can do it

$100 USD in 5 days
(19 Reviews)
5.2
ropez

I have all needed knowlege to complete this task.

$100 USD in 3 days
(0 Reviews)
0.0
pbarbas

Expert, see PM please.

$100 USD in 4 days
(0 Reviews)
0.0