Forum Replies Created

Viewing 15 posts - 121 through 135 (of 169 total)

  • RE: Backup Sets

    BOL is the best place to check doubts like yours.

    Even in sql server central you will find article for this.

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: how to monitor the DB used and unallocated space?

     

    Taskpad view gets data from sysfiles

    Select CONVERT(VARCHAR(12),getdate(),111),Name,Size,FileName from Pubs.dbo.sysfiles

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Detach/Attach invalid SQL Server file

    Before Detach, have you executed any queries to see for sure database was

    up and running. Why I am saying this is 'I think the backup was good' 

    mean you  are not...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Canceling a DBCC Shrinkfile Command

     

    It is safe to cancel  at any time.

    It works as single transaction, probably it can take some time for cancellation as well.

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Tutorials for beginners

    Welcome to sql server community.

    Here are few sites from where you can get good articles to add to your knowledge.

    http://www.sqlservercentral.com

    http://www.sql-server-performance.com/

    http://www.databasejournal.com

    http://www.windowsitpro.com

    vyaskn.tripod.com

    Hope this helps

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Schema Problem

    Detach DB Fileà Copy File à Attach DB File

    This option is always available, but this is...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Creating Database file greater than 2 TB.

    In sql2005 size specifications are 

    Database size 1,048,516 TB

    File size (db) 32 TB and file size (log) 32 TB

    so you do not need to increase the size, probably you are having...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Backup failure with error 112

    A maintenance plan does not overwrite the old backup file. It creates a new backup file, and then deletes the old backup file after creating the new one....

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Transaction log full

    Sarang Bobde,

    This is very interesting solution , but works only if you have rights for Enterprise manager.

    your statement quoted above is misleading ,

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: sql 6.5 backup question

    Instead of NoINIT try INIT option

    this will initialize the backup file everytime it writes to backup file.

    DUMP DATABASE <databasename> to <databasenamebackup> WITH NOUNLOAD, STATS=10, INIT, NOSKIP

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: backup file retention

    declare @sSQLMaintSwitchString  nvarchar(4000)

    set @sSQLMaintSwitchString =

            N' -D "DatabaseName"' +

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Data Migration

    It Will be good , if you can specify size of your db,giant will not

    help here to suggest exact solution.

    you can create few DTS packages to copy data from production db...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Today''''s article - Bogus resumes and unblushing lies

    Fallen Angel,

    For sure this has nothing to do with previous thread.

    Whatever I have to say, was said up front on that thread.

    Even I don't think there is any sort of...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: SQL server Error log in GBs not able to reclycle

    try 

    DBCC ERRORLOG 

    Microsoft recommends using this over Sp_Cycle_ErrorLog

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • RE: Today''''s article - Bogus resumes and unblushing lies

    Bogus resumes and unblushing lies is good article, and I totally agree with Steve and

    all of you except fallen...

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

Viewing 15 posts - 121 through 135 (of 169 total)