Forum Replies Created

Viewing 15 posts - 361 through 375 (of 441 total)

  • RE: Backup and restoration

    Zeal-DBA (8/1/2012)

    i am confused in one scenario please help

    every Saturday full back : 10 PM

    daily differential backup : 10AM

    every hour transaction Log backup started at 10:30

    DB crashed at...

    August 1, 2012 at 7:38 am

    #1520264

  • RE: Help with Backup & Restore

    MyDoggieJessie (7/31/2012)

    It "is" possible...but your primary limitation (depending on the size of the 10 DB's) most likely will be network IO and disk limitations/contention on the server.

    Restoring 10 DB's at...

    July 31, 2012 at 7:53 pm

    #1520058

  • RE: Help with Backup & Restore

    Hi Guys, I have the script to backup all the DB's......Is it possible to restore 10 DB's at the same time to a new instance?....or do I need to...

    July 31, 2012 at 7:08 pm

    #1520047

  • RE: SQL Install Order - Is it Important?

    Arjen Krap (7/29/2012)

    SQLCrazyCertified (7/29/2012)

    Per my understanding, you cannot install more than 1 default instance per box.

    Someone please correct me if I am wrong.

    Regards,

    TA

    Yes, you are correct.

    You can install zero...

    July 29, 2012 at 1:02 pm

    #1518959

  • RE: SQL Install Order - Is it Important?

    Arjen Krap (7/29/2012)

    sqlnovice2001 (7/24/2012)

    Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?

    SQL Server...

    July 29, 2012 at 10:00 am

    #1518935

  • RE: SQL Install Order - Is it Important?

    alexandert680@gmail.com7/24/2012)[/b]

    sqlnovice2001 (7/24/2012)

    Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?

    I can't readily...

    July 28, 2012 at 9:25 pm

    #1518901

  • RE: To find the history of restored DB

    Thanks Hadrian & Anthony.

    TA.

    July 26, 2012 at 2:18 pm

    #1518176

  • RE: Cannot connect to SQL Server 2008 R2 remotely

    I have the error message attached to the this email.

    Did you forget to attach the error message? I cannot find it.

    Regards,

    TA

    July 26, 2012 at 2:17 pm

    #1518174

  • RE: Remove one column from SQL select statement

    capn.hector (7/24/2012)

    it depends on how the user selects the columns they want. i would do any actual dynamic query creation with a stored procedure API level and validate any...

    July 24, 2012 at 6:01 pm

    #1517128

  • RE: Data File Sizes - Best Practice?

    Jeff Moden (7/23/2012)

    SQLCrazyCertified (7/23/2012)

    SouthernConfusion (7/19/2010)

    Anyone have any info regarding Best Practices relating to max data file size for large DB's?

    The scenario is a database of 1 TB in size. ...

    July 23, 2012 at 6:17 pm

    #1516540

  • RE: Data File Sizes - Best Practice?

    SouthernConfusion (7/19/2010)

    Anyone have any info regarding Best Practices relating to max data file size for large DB's?

    The scenario is a database of 1 TB in size. We normally keep...

    July 23, 2012 at 2:26 pm

    #1516468

  • RE: Starting SQL services - Best practise

    MickyD (7/23/2012)

    Hi everyone

    Can anyone tell me , or point me to any documentation that states why SQL 2008 services should be stopped and started from SQL Server Configuration Manager ?

    Sure...

    July 23, 2012 at 7:05 am

    #1516205

  • RE: Tracking server changes

    wanox (7/19/2012)

    What can i use to track changes made st server level

    Yes, please provide more info. Which version are you using? If you are using 2008 for any DML...

    July 21, 2012 at 6:30 pm

    #1515906

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    Jigneshal (7/20/2012)

    I usually use #table in y stored proc. Which is the best to use in SP, #table or @Table variable?

    Thanks

    If you are using this for small set of data,...

    July 20, 2012 at 10:57 am

    #1515658

  • RE: Assist in rebooting the server

    anthony.green (7/18/2012)

    I would only do a backup of the OS using something like Acronis or doing a snapshot if its a VM, SQL should be ok as your not doing...

    July 18, 2012 at 6:23 am

    #1514164

Viewing 15 posts - 361 through 375 (of 441 total)