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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-09 : 07:39:15
|
| Anish writes "Hi.. allHow can i take a full back up of a databases.Suppose we are using MS-SQL and we are having 5 DataBase in that. Can i take the backup of the whole DataBase.like. eg: let a,b,c,....x be the DataBases and i have saved the .mdf and ldf files on a backup folder and can i take the back up of that folder with out stoping the sql server.now we are using the tool BrightStor and not able to take the whole back up by backuping the folder.so, hopw u guyz understand my problem...if u do have any suggession pls do let me know.thanx and regards.anish" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-04-09 : 07:46:44
|
| The only way to create a backup what you can actually restore is by using the BACKUP DATABASE command.Jay White{0} |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-09 : 08:16:16
|
| hth,i agree with page.. u need to take full backups either scheduling using db maintenance plan or a proc taking backup of ur db. u can even do backups across network share.. ! plz refer bol..topic "database backup". and if required u can use third party tool for moving the backed up db to different m/c.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-09 : 13:03:50
|
| Do not backup the folder where the mdf and ldf files exists unless the MSSQLSERVER service is stopped or if the databases have been detached. If you do a backup of the folder when neither of the previous two conditions are true, then you do NOT have a valid backup. To get a valid backup while the databases are online, you will need to run the BACKUP DATABASE command as the other two posters mentioned.Tara |
|
|
|
qwertg
Starting Member
1 Post |
Posted - 2003-04-10 : 12:49:29
|
| Hi RoyalSher, I used to have an impression that SQL Server cannot backup to Network Share. How do you do that?How to backup to Network Share?Thank you,steph |
|
|
|
|
|
|
Data Base Backup