Forum Replies Created

Viewing 15 posts - 46 through 60 (of 64 total)

  • RE: Event Log - SQl server Down

    SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.

    Around the time you found this in your logs ..... you...

  • RE: Replication

    sinhaashish2001 (8/25/2009)


    We can do it in SQL Server 2005 and 2008 using Initializing a Transactional Subscription with a backup.

    I am not sure what you meant there ....

    did you mean...

  • RE: Performance Issues and Sql Server Memory

    whats the SQL Server version ? 2000 or 2005, 32 bit or 64 bit ?

    as a general guideline with the given amount of memory i would leave SQL to manage...

  • RE: unable to backup databases to NAS location on network

    Executing the query "BACKUP DATABASE [master] TO DISK = N'\\\\NASServerSQL\\data\\production\\ServerName\\master_backup_200908251120.bak'

    notsure ... might be very basic .... but do these double \\ sound right ... shouldn't it be a...

  • RE: Replication

    http://www.replicationanswers.com/Articles.asp is good resource .... where you might find an answer to your situation ... some cool tricks there .....

    I dont think you are left with much choice...

  • RE: Login failed for User ".

    first line of the script should be

    USE [ your database name ]

    HTML tags messed it up :pinch:

  • RE: Login failed for User ".

    yes login mappings seems to be the culprit .... you could run the below script to fix any orphaned SQL logins that you might have on the SQL 2005 box.

    USE...

  • RE: job takes different time to complete

    also check for any blocking in the system when your job is running.... you mentioned that there is no other job running when you are running your job, but there...

  • RE: Linked Server Security

    if you have devlopers login as a sql login as opposed to windows one .... you could also map the logins

  • RE: Replication

    restoring msdb database might work in getting the distribution agent back ... but I am not sure if it would solve your problem or replication thinking that I am all...

  • RE: SQL service wont' start

    pls give details of the process used to move tempdb files .... that would be helpful in giving a solution. Also - is this SQL 2000 or 2005 or 2008...

  • RE: Replication

    depends on what kind of replication you want to set up.... but anyways if you are thinking of doing a transactional replication (which is the most common), then the answer...

  • RE: backup retention information

    any idea how to check that for sql 2005 ??

    sysjobsteps table has details of an ssis package (which is created for the maint plans). is there a config file...

  • RE: Changing Database name

    not required

  • RE: Understanding the Algorithms used by SQL Server

    I agree with the above post .... the best insider info available is in the book Inside SQL Server 2000. but then it only talks about overview of the process,...

Viewing 15 posts - 46 through 60 (of 64 total)