Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.

If you will...

Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.

If you will...

Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.

If you will...

Hello,

Can you check if you do have access to the following backup file:

'C:\Logshipping\PrimaryServer\MASK.bak'

sometime if system backups are running and copying this than it may create this kind of problem. If...

I too have seleted option 3 hence wrong.... BAD LUCK!!

I do agree with STEVE JONES; we need to be positive why people are more worried about points more than that...

Do you have backup available?

If SQL Server is using Mixmode authentication. One can use windows Administrator to login and change sa password.

Refer following link to narrowdown your problem:

http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

Yes, Gila you are correct...

Here Read_Only means database which is not participate into Logshipping.

After restore when you put any database into READ_ONLY mode. Than you will able to detach and...

how you will find SPID?

check the hostname column...

refer the COUNT function

http://msdn.microsoft.com/en-us/library/ms175997.aspx

You can think about creating Alert like 32042 to send notification. This is just example error 32042 is raised when the threshold reach for the t-log unsent.

HTH

What exactly would you like to do?

Both the link provided is v.good.

But I guess you need to slightly modify the code in both of the above link to meet your requirement.

Hello Jeetendra,

Your Current Backup Plan is good i.e. Full backup weekly and Diff. Backup Daily considering 200 GB Database.

Now your Log shipping will not affect your Backup Plan.

Second, after setting...