Please go through the below post,

http://www.sqlservercentral.com/Forums/Topic604457-146-1.aspx

I think u will be very clear after that.

disk drive filling up...

Means Full backup also contain commited transactions, which are also commited in transaction logs which are backuped during Full backup.!!!

i have taken a log backup with truncate only, the chain of log sequence break..

but i nedd to take log backup with truncate..bac of log file size is full..

Is there...

I have heard about some procedure like..SP_OAcreate ,...

which is used with OS Objects.

But i don't know how to use it?

can it solve my problem?

Yes, u have described, but at that i was littlebit confused.

Thanks guy.

so, your meaning is we should not apply transaction log backups which are generated during full backups, only apply which are generated after full backup..otherwise it will give error.

My query...

Hi i can get both HA and HP from Active/Passive clustring .

But this very costly in comparision to Mirroring/Shipping.

in this ,When one instance is fail it is auto tranfer to...

Is there any query to Determine the sequence of all full, diff and transactional log backups?

How we can find sequence of those backups?

Suppose i have 5 full backups , 15...

I want to insert data from XML File, which has not fixed format.

But XML file has first node is fix and which is parenr node , but except first node...

I have set to network acess,

But the problem is :

In network storage devive , we have given username and password of that network device domain user for security purpose.Means we...

But how can i copy to network storage device...

when i run command

xp_cmdshell 'dir "nas01\folder"'

or

backup database master to disk = '\aso1\folder\master.bak'

raised error : Specified path unavailable..so i can not take...

Anyone can tell me?

I got some script to bifurcate memory as per database..

But is there any?

My Server eaten more than 1 GB?

Why more ?..How to identify memory eaten by server?

I have taken backup on networh storage device, and the folder have username and password required to open that folder,

When i take backup to taht folder,,i got above error which...

SQL logins..

But i think concern with network storege device?