Viewing 15 posts - 121 through 135 (of 167 total)
Resolved. login123 password expired. From now on, it’s set not to expire.
February 1, 2010 at 8:46 am
Thanks to all.
We had a 50 min power outage. We did not get any outage notification from hosting company in time. Our websites are down, no rdp to servers during...
January 20, 2010 at 8:47 am
The_SQL_DBA (1/19/2010)
Make sure all the services are running properly. Also a DBCC check on the important databases would be good. Suggest reading this articleHTH...
Thanks for the reply..everything is good now
We...
January 19, 2010 at 10:10 am
Raghavender (1/17/2010)
We have created a maintenance plan for T-Log backups. From the last 2 days, its getting failed. We have checked the selected databases option. 3 days back we...
January 18, 2010 at 1:05 pm
GilaMonster (7/9/2009)
Query sys.databases. What's the value of log_reuse_wait_descr for that database?
Hi GilaMonster, I was just going through this thread, just want to know
what is the value of log_reuse_wait_descr to shrink...
January 13, 2010 at 8:45 am
If shrinking datbase/logfile causes index fragmentation and poor performance. Then why that option is there in SQL Sever.
If you don't shrink logfile, lets say logfile grows rapidly and there...
January 11, 2010 at 2:38 pm
Thanks to all, i was selecting wrong back up file
So Now i want to verity the updated data
I have one full backup file 12/31/2009 12:20AM
Diff backup file 12/31/2009 06:35 AM
TLOG...
January 6, 2010 at 12:25 pm
Krasavita (1/6/2010)
Thank you, I fixed it, someone were running along a query and I reboot server and it fixed it
You mentioned this is a production server. Do you have...
January 6, 2010 at 8:34 am
Thanks for your reply GilaMonster!
Presently I am saving database changes script/code, input/outpur and also approved email in a network share for future audit.
In SQL is there any way to perform...
January 6, 2010 at 8:18 am
Bru Medishetty (12/29/2009)
December 29, 2009 at 2:37 pm
Steve Jones - Editor (12/29/2009)
December 29, 2009 at 2:35 pm
No reports are deployed in secondary server.
Your ansewer is confusing to me. Can you please explanin in details.
We are moving our production to a another server, we will use this...
December 29, 2009 at 1:51 pm
Some reports are there.
Restoring Reporting databases are not like normal backup and restore?
I am planning to below steps
1. Stop report server
2.detach database in primary server
3.copy mdf and ldf file to...
December 29, 2009 at 12:54 pm
Currently we are not using Reporting server. Earlier we used to get a report for internal application(not for any client application).
What you advice
December 29, 2009 at 11:40 am
Bru Medishetty (12/29/2009)
The only restriction I know and and am aware of is that a backup from a higher Version cannot be restored on an earlier version. Like...
December 29, 2009 at 10:25 am
Viewing 15 posts - 121 through 135 (of 167 total)