January 23, 2009 at 3:26 pm
We have SQL Server 2000. I am looking for simple scripts to do a full db backup and transaction log backups. I would also like the scripts to restore a full db backup and transaction log backups. (I know how to do it with the GUI.) Please provide me an example using the Pub or Northwind DBs. Also, how would I schedule these backups using scripts? Would I have to create a Job that execute T-SQL? Say, if I want the full backup to run at 10 P.M. nightly and the T-Log to run every 4 hours daily.
Thanks in advance, Kevin
January 28, 2009 at 6:03 am
hello
to restore try this
CREATE PROCEDURE _restore_database_backups AS
RESTORE DATABASE databasename
FROM DISK = path to backupfile
WITH
REPLACE
GO
greetings Marco Donders
January 29, 2009 at 9:09 am
Hi,
You can sample scripts from many places. But to run them at specific time, you need to create the Job and run the script within the job itself. Once the job is created, you need to schedule it as per your timings to take the backup. You may create the job for Restore also but don't put any schedule. You must run it manully only when you need to restore the backup database.
January 29, 2009 at 9:14 am
You may also read this article for more information on scripting the Backup and Restore.
http://www.mssqltips.com/tip.asp?tip=1584
Regards, Atul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply