|
|
Posted by GZ on 02/11/07 12:25
On Feb 8, 11:42 pm, "sjoshi" <sjo...@ingr.com> wrote:
> Hello
> I'm seeing the backup using SMO fails with big databases (>15GB). I
> have a 2GB database and I can see the command go thru. in Profiler but
> after it's about 50-70% done, I get an exception saying backup failed.
> There is no details on the SQLServer log.
>
> Here's the code snippet:
>
> bk.Initialize = m_backupInit;
> bk.PercentCompleteNotification = 10;
> bk.PercentComplete += new
> PercentCompleteEventHandler(bk_PercentComplete);
> bk.SqlBackup(m_Server);
>
> Here's the command as captured by SQL-Profiler:
> BACKUP DATABASE [Test_MODEL] TO DISK = N'D:\Temp
> \Test_Model_Backup.dat' WITH NOFORMAT, INIT, NOSKIP, REWIND,
> NOUNLOAD, STATS = 10
>
> Has anyone else seen this. The wierd thing is it works using old SQL-
> DMO.
>
> thanks
> Sunit
I would check the event log as well, there may more information there.
I have too encountered situations which are similair, however, never
where there was absolutely no information in any of the typical log
locations. 15 gig is not paticulary large, I am sure there must be
more to it. What is the result when you execute via OSQL prompt?
Cheers,
G
Navigation:
[Reply to this message]
|