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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-09-20 : 06:07:29
|
| Dear UserI am using sql2008 server . I will give a backup of database. i have call following execmaster.dbo.xp_backup_database but the error is could not find store procedure 'master.dbo.xp_backup_database'please tell me where is the master.dbo.xp_backup_database in sql2008 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-09-21 : 02:31:23
|
| thanks to replay Tarai have used your new backup sp(isp_Backup) in sql2008. i have excute this sp in following EXEC [dbo].[isp_Backup] @path = N'E:\test\', @dbType = 'User', @bkpType = TLog, @retention = 1, @bkpSwType = 'NV', @archiveBit = 0, @copyOnly = 0In my database to create two other user created database.but it gives only model database log backup and other database message is Skipping transaction log backup of dbnameso please tell me what is error i have give log backup of all user created database |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-09-22 : 00:12:06
|
| thanks to repalyyes our database recovery model is simple then i have set fullthen it working well.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
master.dbo.xp_backup_log in sql2008