Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 9,244 total)

  • RE: Issues with backup to a network drive

    has someone changed the run as on the job step maybe?

    running as the virtual NT SERVICE account is not recommended for services that require network access, what has changed since...

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

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

  • RE: SQL Server Availability Group Listener problem

    travisrunyard (2/29/2016)


    Perry Whittle (2/27/2016)


    check this first see if it helps

    [ulr=http://blogs.msdn.com/b/sambetts/archive/2014/02/04/multi-subnet-clustered-sql-registerallprovidersip-sharepoint-2013.aspx]http://blogs.msdn.com/b/sambetts/archive/2014/02/04/multi-subnet-clustered-sql-registerallprovidersip-sharepoint-2013.aspx[/url]

    I've already ready that and just about everything else on google about this topic. This doesn't help as this basically tells...

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

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

  • RE: List of Direct Users

    bubby (2/29/2016)


    I just need help to get a proper query with which I can generate the report for direct users connecting to my SQL instance,

    Is there any way to see...

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

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

  • RE: How can I restart LSRestore step in Log Shipping process

    check sysprocesses and hard line is kill the users spid.

    Otherwise call them and ask them to rescind their connection\session

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

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

  • RE: Log initial size

    gorripativ (2/26/2016)


    Hi,

    I have set my db log intitial size as 512 MB and autogrowth as 512 MB. The db is in full recovery model and tlog runs every 15 min....

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

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

  • RE: SQL Server Availability Group Listener problem

    check this first see if it helps

    http://blogs.msdn.com/b/sambetts/archive/2014/02/04/multi-subnet-clustered-sql-registerallprovidersip-sharepoint-2013.aspx

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

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

  • RE: How can I restart LSRestore step in Log Shipping process

    Firstly check the state of the primary database and report back on that.

    also check the results of this query run against the primary and secondary

    select name, differential_base_lsn, differential_base_time from sys.master_files

    where...

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

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

  • RE: VMWare version

    ramana3327 (2/24/2016)


    Hi,

    Is it possible to find which vmware version we are using from SQL Server or from windows?

    Whn I run @@version

    I received the result Microsoft SQL Server 2014 standard...

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

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

  • RE: Massive Performance Problems when using Snapshots

    kevaburg (2/24/2016)


    It was the typical "15 seconds for IO" message that I associate with contention. What bothered me the most is that within the Task Manager only one datafile...

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

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

  • RE: How can I restart LSRestore step in Log Shipping process

    please don't double post, see my reply here

    http://www.sqlservercentral.com/Forums/Topic1763576-1549-1.aspx?Update=1

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

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

  • RE: How can I restart LSRestore step in Log Shipping process

    lw1990 (2/23/2016)


    Hi,

    I have a log shipping process set for a long time and the restore step is failed on the secondary server while the backup step from the primary...

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

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

  • RE: What are the pros and cons of running SQL Server on the non-preferred node?

    preferred node is just a terminology. It's only considered by the auto failback option in the cluster if it's enabled.

    From the design and licensing standpoint, if you're not running the...

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

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

  • RE: Zero downtime solution migrating from SQL 2012 Web to SQL 2104 Enterprise Always On

    techtnt-630432 (2/23/2016)


    Hi all,

    I've been presented with the challenge of handing a migration from our current SQL 2012 Web (64 bit) edition (Windows Server 2012 R2) to our new 2014 Enterprise...

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

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

  • RE: Database Admnitration, delete FILEGROUP

    please start by posting results of the following query

    select 'Table [' + object_name(i.object_id) +

    '] has index [' + i.name +

    '] on partition scheme [' + ps.name + ']'

    from...

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

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

  • RE: Log Shipping or Replication

    davidku (2/22/2016)


    Hi DBAs,

    Just wonder anyone tried to use Log Shipping on MSSQL 2012 collecting data from MSSQL 2008R2 and MSSQL 2005 databases ?

    If you do, what's the challenges you encounter...

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

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

Viewing 15 posts - 1,336 through 1,350 (of 9,244 total)