Forum Replies Created

Viewing 15 posts - 226 through 240 (of 240 total)

  • RE: Tempdb data file fills up very often

    Can you see if something is leaving allocated pages in tempdb.

    select * from sys.dm_db_task_space_usage

    where internal_objects_alloc_page_count <> 0

    Anything which has an high alloc and low dealloc. Then whatever that spid is...

  • RE: Reporting Services

    Easily done Via SSRS configuration tools.

    If you want to keep the original SSRS dbs for rollback.

    1 Backup the dbs with copy.

    1a Backup SSRS encryption keys\cert.

    2. Restore the dbs as...

  • RE: SQL 2000 Install

    It looks that way. It's a no go for me due to the connection issues and the fact I'm running on Windows 2008 R2 x64 bit which it is advised...

  • RE: SQL 2000 Install

    Thanks Steve.

    Tested, JUST FOR INFO.

    SQL 2000 installed fine, but with remote connection issues.

    Checked the usual

    Browser Service running

    Permissions

    TCP\IP enable

    Port enabled in Firewall

    SP4 installed server rebooted.

    Still no remote connection.

    This is all...

  • RE: SQL 2000 Install

    Sorry Steve I think you misunderstood the question.

    I have used SQL 2000 many a time as a named instance.

    As I haven't worked with SQL 2000 for about 3 years now.

    My...

  • RE: Replacing the SSRS server, but not the DB server, how to migrate reports?

    Use the Repoting services configuration manager on the system you want to move.

    Backup the RS encryption cert . Backup the RS and RSTEMPdb with copy.

    Install SSRS on new machice....

  • RE: SQL server agent doesnt start

    Is there a Domain Policy in effect that stops an account from running as a service.

    Is the folder (WINDOWS FOLDER for SQL agent) accessible by the account running the service?

    Can...

  • RE: Tempdb grows suddenly.

    Run this...

    select * from sys.dm_db_task_space_usage

    where internal_objects_alloc_page_count <> 0

    See which spid has an high 'internal_objects_alloc_page_count'

    and a low 'internal_objects_dealloc_page_count'

    then see what these spids are doing.

    Do you use Service Broker at...

  • RE: Shrink does not release space

    There is a lot more work needed if this is to be done properly.

    Shrinking the data file is simply a bad idea and a simple index rebuild is not sufficient.

  • RE: Shrink does not release space

    Can't believe no one has pointed out that is not a good idea to shrink Production DBs.

  • RE: Shrink does not release space

    Can't believe no one has pointed out that is not a good idea to shrink Production DBs.

  • RE: Always On Primary Offline = Secondary Offline

    ANBODY??

  • RE: Backup restore ENCRYPTED database!!!!!

    Your question is mis-leading BACKUP/RESTORE would indicate that a) you want to back it up and b) you would like to restore.

  • RE: Backup restore ENCRYPTED database!!!!!

    Backup as normal, after the cert has been backed up.

    Restore using Cert and Private Key T-SQL

    Something like this to BACKUP the CERT.

    TEST first.

    CREATE CERTIFICATE NorthwindCert

    FROM FILE = 'C:\NorthwindCert_File.cer' ...

  • RE: Backup restore ENCRYPTED database!!!!!

    You need to read up on TDE.

    The server A db needs to have the Certificate backed up.

    Server B needs needs to be able to restore using the certificate. Copy the...

Viewing 15 posts - 226 through 240 (of 240 total)