Forum Replies Created

Viewing 6 posts - 31 through 36 (of 36 total)

  • RE: DataBase Restore Problem

    Amit Gupta (11/21/2008)


    According to this i restore 1st DIFF #3 then DIFF #2 after this DIFF # 1

    then actually what happen lost any date or successfully restore...

  • RE: Access Deny Sql Server Agent

    Hi,

    can you not log in because the administrator has lockt the server or do you have not enough rights to start?

    if you have the right to start and stop the...

  • RE: Need help deleting a second log file.

    Hi,

    try this:

    use "database"

    go

    DBCC SHRINKFILE

    ( "logfilename" , EMPTYFILE )

    go

    alter database "databasename" remove file "logfilename"

    go

    regards

  • RE: Recovery a SQL 2000 server on an alternate server (i.e. after a major server failure).

    Hi,

    when i see this error

    Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL$EASYSHIP\data\model.mdf' may be incorrect.

    2008-08-06 12:26:57.27 spid8 Starting up database 'msdb'.

    2008-08-06 12:26:57.27...

  • RE: log file deleted accidently :(

    Hi,

    if you have a fullbackup you only need to check the "overwrite the existing database" option in the restore database menu.

    or, with more fun, try this:

    To attach a database with...

  • RE: SQL Server backups over the Network

    Hi,

    because of timeoutproblems with the network and/or firewall (the network admins didnt see any problems on the network 😉 )we do a local dump and then copy the dump...

Viewing 6 posts - 31 through 36 (of 36 total)