Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2010-12-01 : 23:42:07
|
| Hi,can any one tel me . take a backup , create new databae restore backup after when database crashes. tel me how to do and a stored procedure to do above |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-02 : 02:40:41
|
| Hi,The article explains how to take backup and restore.http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backupsIn same screen you find a button on top with caption "Script" which can be used for generating SQL script for the action.You can take the script and embed it in sp.Regards,BohraI am here to learn from Masters and help new bees in learning. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-02 : 03:03:26
|
| "create new databae restore backup after when database crashes"No need to create database first, you can just restore backup file and RESTORE can create the database (if it does not already exist) - or it can Replace an existing database |
|
|
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
Posted - 2010-12-02 : 06:19:03
|
| Hi,Can u tel me how to store backup on remote machine |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-12-02 : 07:20:20
|
quote:
Originally posted by yadhu_cse
Hi,Can u tel me how to store backup on remote machine
For this question you have opened a new thread!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153668
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Database backup and recover