SQL_Latin1_General_CP1_CI_AS is the sql server collation

When I check for TCP?IP ports

both default & named instances are using default 1433

For each instance needs one browser service?

I can see

Sql Integration servecies 11.0 & Sql Integration servecies 12.0,

Sql server (Named) & Sql server (default),

Sql Agent (named) & sql Agenet (default)

but...

Hi,

Ours is Sql Server 2008r2. So used the compression

I used the below code

backup database Testdb to

disk = '\\h:\Backups\Testdb_full__2015032200518_1.bak'

, disk = '\\h:\Backups\Testdd_full__2015032200518_2.bak'

, disk = '\\h:\Backups\Testdb_full__2015032200518_3.bak'

, disk = '\\h:\Backups\Testdb_full__2015032200518_4.bak'

, disk...

Hi Tac,

other than the old backup it has free space 600GB

Thanks for the reply.

What do you mean by same site and cross site. Do you mean same datastorage?

But we have some constraints to change the full backup to diff. Some other servers needs to refresh with everyday backup but there is no communication b/n server to set...

I am clear about the steps but needs to find the latest backup from folder when there is no time stamps associated with backups . Is it possible through execute...

Sorry guys.

I can't able to run anything on the other server. I have the access on the backup server only. From the backup server, I have to use some logic...

Yes. We have 1hr t-logs but no differentials

The primary server is not in our control. We can't take backups on that. Other team will keep the backups in the middle and agree to give us access on...

Are there any performance impacts by enabiling trace flag 2371

In my case also DBCC TRACESTATUS (2371) is not showing any thing.

Yes. I did

Thank you