Peruttu

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

Taidot: Komentosarjan asennus

Näytä lisää: 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

Tietoa työnantajasta:
( 17 arvostelua ) Dallas, United States

Projektin tunnus: #205941

3 freelanceria on tarjonnut keskimäärin 100 $ tähän työhön

momleetech

we can do it

100 $ USD 5 päivässä
(19 arvostelua)
5.2
ropez

I have all needed knowlege to complete this task.

100 $ USD 3 päivässä
(0 arvostelua)
0.0
pbarbas

Expert, see PM please.

100 $ USD 4 päivässä
(0 arvostelua)
0.0