Forum Replies Created

Viewing 15 posts - 121 through 135 (of 167 total)

  • RE: login failer for user

    Resolved. login123 password expired. From now on, it’s set not to expire.

  • RE: Power Outage

    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...

  • RE: Power Outage

    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 article

    HTH...

    Thanks for the reply..everything is good now

    We...

  • RE: Maintenance Plan

    Raghavender (1/17/2010)


    Hi Team,

    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...

  • RE: Log file growth

    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...

  • RE: Reducing the Data and Log file Size in SQL SERVER 2005

    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...

  • RE: restore database

    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...

  • RE: 'tempdb' is full

    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...

  • RE: Ensure protection of db tlogs

    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...

  • RE: Quick question on restore database

    Bru Medishetty (12/29/2009)


    If you are going to overwrite the mdf and ldf files at the secondary server (new server) the reportserverDB existing on that server will be overwritten and will...

  • RE: Quick question on restore database

    Steve Jones - Editor (12/29/2009)


    Note that moving those databases to the secondary server, either with detach/attach or just a copy over of the mdf/ldf (note that you need to stop...

  • RE: Quick question on restore database

    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...

  • RE: Quick question on restore database

    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...

  • RE: Quick question on restore database

    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

  • RE: Quick question on restore database

    Bru Medishetty (12/29/2009)


    Yes you can.

    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...

Viewing 15 posts - 121 through 135 (of 167 total)