Forum Replies Created

Viewing 15 posts - 706 through 720 (of 1,065 total)

  • RE: How to implement Log Shipping Using SSIS ?

    RV-813525 (4/6/2010)

    At the end of day I have to ship the logs from each of the client's database and sync to the centralized database.

    Log shipping does not work like this....

    April 8, 2010 at 3:28 am

    #1148109

  • RE: What is SSIS ?

    arjung (4/7/2010)

    Can somebody please help me about what is SSIS?

    Thanks,

    Arjun

    SSIS stands for SQL Server Integration Services.

    It is an ETL (Extract-Transform-Load) tool.

    You can create SSIP packages using BIDS (Business Intelligent Development...

    April 8, 2010 at 3:05 am

    #1148100

  • RE: Server Maintenance

    Ratheesh.K.Nair (3/30/2010)

    Thanks Suresh,

    Hope u meant that differential backup and full backup can be appended to the same file.

    Yes.

    Any (full or diff) backup can be appended to an existing backup file.

    For...

    March 30, 2010 at 5:48 am

    #1142084

  • RE: Backup Restoration

    Ratheesh.K.Nair (3/29/2010)

    Hi Experts,

    Is it possible to restore latest differential backup after restoring an old full backup?

    No, unless the OLD backup is base for the differential backup.

    You will get following error:

    This...

    March 30, 2010 at 3:40 am

    #1142036

  • RE: Server Maintenance

    Ratheesh.K.Nair (3/30/2010)

    Adding to above

    Is it possible to append differential backup to a full backup?

    Yes. It is possible to take a backup to existing backup file.

    However it is recommended to...

    March 30, 2010 at 3:22 am

    #1142031

  • RE: Backup File Missing

    Sometimes backup files are moved to some other place.

    For example backups are taken to local disk to reduce time and avoid network issue.

    Later the backup files are move...

    March 29, 2010 at 6:02 am

    #1141352

  • RE: About 70-450 Exam

    Congrats!

    You took only one month to prepare for the exam 🙂

    Regards

    March 19, 2010 at 4:27 am

    #1136575

  • RE: How to check SQL Server Login and Password Properties? (7 Questions for DBA)

    Reo (3/5/2010)

    Hi,

    I have this on production server.

    windows account policies are good if I'm going to create new login.

    My problem is that I want to find out thoses login who...

    March 9, 2010 at 2:31 am

    #1130511

  • RE: Transaction Replication

    Please post the errors you are getting.

    Without seeing the error message, it is difficult to help.

    Replication can be down for different reasons.

    March 8, 2010 at 2:35 am

    #1129880

  • RE: Replication Indexes Best Practice

    Eugoogley (2/25/2010)

    Hi

    We have one database which publishes to another (SQL 2005 - transactional replication). The subscriber is used by a number of applications where the publisher is only ever used...

    March 2, 2010 at 2:36 am

    #1126904

  • RE: Equivalent of Oracle Streams

    I am not familiar with Oracle Streams.

    SQL Server has features likes

    1) DML/DDL triggers

    2) Service Broker for asynchronous processing

    3) Change Data Capture

    Replication has granular control. For example, you can replicate...

    March 2, 2010 at 2:29 am

    #1126901

  • RE: Minimum rights for running a job.

    Please check database roles SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole on msdb database.

    March 2, 2010 at 2:10 am

    #1126896

  • RE: NOLOCK in update statement

    Joe-420121 (2/22/2010)

    could some explain me what is the effect of the following two statements; Which one better one? both same?

    update i set i.name= 'MR Y' from inventory i with (NOLOCK)...

    February 22, 2010 at 10:41 pm

    #1123426

  • RE: How can we extract the complete list of users for a database and whether they are active or not

    sys.dm_exec_sessions -- 2005

    sysprocesses -- 2000

    February 18, 2010 at 5:50 am

    #1120833

  • RE: RAM utilization on sql server

    Anamika (2/17/2010)

    Hi All,

    Thanks a lot for your inputs.

    I'm working on those.

    and i have installed performance dashboard reports to find out the time taking queries.

    Once i find some significant...

    February 17, 2010 at 10:53 pm

    #1120669

Viewing 15 posts - 706 through 720 (of 1,065 total)