Viewing 15 posts - 916 through 930 (of 1,179 total)
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:26 pm
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:25 pm
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:25 pm
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:19 pm
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 27, 2009 at 10:46 pm
Do you have backup available?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 25, 2009 at 6:23 am
If SQL Server is using Mixmode authentication. One can use windows Administrator to login and change sa password.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 21, 2009 at 2:21 am
Refer following link to narrowdown your problem:
http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2009 at 1:16 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2009 at 1:05 am
how you will find SPID?
check the hostname column...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2009 at 12:42 am
refer the COUNT function
http://msdn.microsoft.com/en-us/library/ms175997.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2009 at 12:39 am
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 19, 2009 at 1:21 am
What exactly would you like to do?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2009 at 5:33 am
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.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2009 at 12:58 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 18, 2009 at 12:19 am
Viewing 15 posts - 916 through 930 (of 1,179 total)