Hi all,
Sql server 7.
I have been given task to schedule transaction log backup for every six hours. Pls give me the steps as how to schedule a transaction log backup.
TIA
Waiting for replyUhhh with job scheduler?
That's the easy way...
with code you'll need to use system stored procedures...look them up in BOL...
sp_Add_Job, ect|||sorry if i am not clear, i want to know how to take transaction log backup.|||Do you have client tools installed?
Do you have Books Online?
Look up BACKUP LOG...
If you want to do it with T-SQL
You could use the DB Maint Wizard in Enterprise Manager as well...
Showing posts with label steps. Show all posts
Showing posts with label steps. Show all posts
Monday, March 26, 2012
logtransaction backup
Friday, March 23, 2012
Logshipping steps
I need to set up Log shipping in my company.
Can any one tell me what are the prequisites and steps.
Since i am going to do it for the 1st time will require some simple /basic / easy to understand wordings.
Any site id will be ok.
Thanks in advance..Try these:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
http://www.microsoft.com/italy/technet/support/mvp/log.asp
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/prodspecs/logship2.asp
HTHsql
Can any one tell me what are the prequisites and steps.
Since i am going to do it for the 1st time will require some simple /basic / easy to understand wordings.
Any site id will be ok.
Thanks in advance..Try these:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_8elj.asp
http://www.microsoft.com/italy/technet/support/mvp/log.asp
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/prodspecs/logship2.asp
HTHsql
Subscribe to:
Posts (Atom)