Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 9,244 total)

  • RE: Database suspect.

    Satya_0000 (3/17/2012)


    After the server restart , one of the database is not coming online. any help to resolve

    Put the database into emergency mode and run dbcc checkdb, post back the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping issue

    shashi_1409 (3/16/2012)


    I have checked the Job history , jobs are running fine with no errors and how do we check data transfer latency, do you mean delay restoring backup setting...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Logshipping Mode change

    Ziljan4 (3/9/2012)


    Is it possible to change the recovery model of a log-shippped DB from Recovery to Standy mode and vice versa using a script?

    Are you wanting to switch roles on...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: DTA - How to delete the session?

    use the stored proc dbo.sp_DTA_help_session to get session details then use dbo.sp_DTA_delete_session to remove it. These procedures are in the MSDB database 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping issue

    shashi_1409 (3/16/2012)


    I have checked the Job history , jobs are running fine with no errors and how do we check data transfer latency, do you mean delay restoring backup setting...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: MSCS Server and VmWare

    rabensql (3/16/2012)


    Hello,

    Thank you for your reply

    We use the last version of VMWare VCenter 5/ VSphere 5 / ESX 5.

    HA, DRS and FT are implemented with 2 geographically separated site.

    OK, when...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Unable to shrink an almost empty ndf file

    sbaker-757360 (3/16/2012)


    The problem filegroup (set as default) which I will call Filegroup1 only had one ndf file in it.

    what is the name of this filegroup within SQL Server, this is...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: MSCS Server and VmWare

    which edition\version of VMWare are you using?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Failover Cluster WMI

    M.Kahn (3/16/2012)


    I got Failed Error when i am going to install SQL Server Failover Cluster sql 2008 r2. Please have a look on print shot ... i need help to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Unable to shrink an almost empty ndf file

    sbaker-757360 (3/16/2012)


    Perry,

    I was not clear in my original post. I tried to clear it up a bit in following posts.

    The 300GB Table that had mass deletes performed was copied to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Unable to shrink an almost empty ndf file

    sbaker-757360 (3/16/2012)


    The ndf file where the old 300GB table will not shrink down below 52GB even though there is only 2GB of data left in the filegroup.

    Questions

    how many files are...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log shipping issue

    Check the log copy and restore jobs for errors

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Backup Job failed due to enough disk space

    Is backup done via a script or a maintenance plan

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Privileges to a particular folder in ssrs

    gmamata7 (3/15/2012)


    sql server 2005.

    Thanks for your inputs

    You've posted in the SQL Server 2008 forum!!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Backup Job failed due to enough disk space

    kodalisridevi (3/15/2012)


    my backup job is running everyday but, from the past 2 days it is failing due to :

    18210 :

    BackupMedium::ReportIoError: write failure on backup device 'D:\SQLServer\MSSQL\BACKUP\TPO_ProdData\TPO_ProdData_db_201203150030.BAK'. Operating system error 112(There...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 5,836 through 5,850 (of 9,244 total)