SQL Server Performance

Search Results

Search Again
  1. thewebhosting

    MS SQL Database server migration query

    Thread by: thewebhosting, Apr 1, 2010, 1 replies, in forum: SQL Server 2005 General DBA Questions
    I have two MS SQL standalone servers. One server has MS SQL 2000 standard edition while on other hand, MS SQL 2005 workgroup edition. Now, how do I...
  2. thewebhosting

    DB backup and restore

    Post by: thewebhosting, Apr 1, 2010 in forum: General DBA Questions
    Hi, Check with SQL Database Recovery Tool. It will restore the database from MDF file much faster then actual database restore process.
  3. thewebhosting

    Export Data from Excel to Sql server

    Post by: thewebhosting, Mar 21, 2010 in forum: SQL Server 2005 General DBA Questions
    Hi, This is the best example for Export data from Excel and import it in MS SQL: http://support.microsoft.com/kb/321686
  4. thewebhosting

    Avoid transaction log

    Post by: thewebhosting, Mar 20, 2010 in forum: SQL Server 2005 General DBA Questions
    Hi, It is not possible to disable the Transaction logs. You can set auto shrink the logs features so you may not face any issue of log file full...
  5. thewebhosting

    Cannot create a connection to data source

    Post by: thewebhosting, Mar 20, 2010 in forum: SQL Server 2005 Reporting Services
    Hi, Make sure that your database server provides right to access it from remote server. First check the connection locally. Also reset the database...
Showing results 1 to 5 of 5
Search Again