Forum Replies Created

Viewing 15 posts - 45,676 through 45,690 (of 49,571 total)

  • RE: sql server 2005 stops every night

    Anythng in the SQL error log from the time of the stop?

    July 16, 2008 at 1:16 am

    #843557

  • RE: Restoring differential backup on other server

    Abhijit (7/16/2008)

    It menas if i'll not take the full2 then I can restore the database in below sequece...

    Full 1, Diff 4, Tran backups 11,12

    correct?

    Yes, if full 2 was not...

    July 16, 2008 at 1:14 am

    #843556

  • RE: Index strcture

    Abhijit (7/16/2008)

    Now want to build the indexing strategy on both tables. could anyone help me out in this?

    Not enough information.

    Are there any foreign keys? How are you going to be...

    July 16, 2008 at 1:13 am

    #843553

  • RE: How do I reduce or eliminate logging?

    Abhijit (7/16/2008)

    In this case instead of trncating the logfile if i'll shrink the log file what will happen?

    Provided there's unused space within the log file, the size of the file...

    July 16, 2008 at 1:07 am

    #843549

  • RE: Restoring differential backup on other server

    Abhijit (7/16/2008)

    Gila,

    Can we perform the restoration strategy this below manner..

    1 Full say full1, full2

    2 Differential say diff1, diff2, diff3....

    3 Transaction say trn1, trn2....

    When restoring the database.. Suppose u have...

    July 16, 2008 at 1:00 am

    #843546

  • RE: Microsoft Certified Master: SQL Server 2008

    matt stockham (7/15/2008)

    If you get the MCP newsletter, there is information in there incuding a few links. This is basically the ranger program opened up to anyone with the...

    July 16, 2008 at 12:45 am

    #843541

  • RE: query

    Marios Philippopoulos (7/15/2008)

    last_execution_time[/b] value in the DMV is, say, from a week ago, wouldn't it be safe to assume that query plans that are a week old...

    July 16, 2008 at 12:41 am

    #843539

  • RE: Pointing multiple SQL Servers at a single MDF (on a SAN) with Read Only access

    Roust_m (7/15/2008)

    But apparantly it does not allow you to share a production database (read/write) with reporting servers in read only mode.

    You are correct, it does not. All of the databases...

    July 16, 2008 at 12:40 am

    #843538

  • RE: LOG File Growth

    rinu philip (7/15/2008)

    The result gave : dataname,FULL,LOG_BACKUP

    In the query : SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases

    what does 'log_reuse_wait_desc' --mean?

    Its the reason that the space in the log file is...

    July 16, 2008 at 12:34 am

    #843537

  • RE: DBCC Reindex then ??

    SQL King (7/15/2008)

    Damn!! Thanks for that.

    Well, i guess I have to stick with the old plan where I have Full Backup and full recovery. But I am definately taking the...

    July 16, 2008 at 12:29 am

    #843535

  • RE: clustered index and pK

    Abhijit (7/15/2008)

    It true that when we define the primary key by default it create the clustered index, but its not true you can define it as non clustred index...

    July 16, 2008 at 12:24 am

    #843531

  • RE: Difference between Transaction Log & Database Log File

    Transaction log entries are only purged on checkpoint if you are running in simple recovery mode. If you are in simple recovery mode, you cannot run log backups at all.

    In...

    July 15, 2008 at 12:51 pm

    #843353

  • RE: DBCC Reindex then ??

    SQL King (7/15/2008)

    Thanks for all these answers above. Not only I have made myself clear, but I have reconfigured the way my database was set to now. I do have...

    July 15, 2008 at 12:47 pm

    #843349

  • RE: Regarding extended stored procedure.

    What do you get returned by the following (fix directory and server names if necessary)

    exec master..xp_cmdshell 'dir \\Server A\*.*'

    July 15, 2008 at 12:34 pm

    #843338

  • RE: Any Advice on Tuning

    GSquared (7/15/2008)

    This Solomon name on each table looks very familiar. Did I do something else with this database a while back?

    Probably. This isn't the first time Mike's posted a...

    July 15, 2008 at 12:27 pm

    #843334

Viewing 15 posts - 45,676 through 45,690 (of 49,571 total)