Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 4,745 total)

  • RE: Get a list of database names and file locations

    join sysdatabases to sysaltfiles on dbid (in master database)

    ---------------------------------------------------------------------

  • RE: Cluster Move

    then you should be fine, just don't drop them.

    same IP addresses?

    ---------------------------------------------------------------------

  • RE: Cluster Move

    sounds logical.

    Stop all applications connections to the cluster before bringing down the primary at least.

    Back up all the databases as a precaution.

    I presume this is a physical move of the...

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    If you try and move the files by restore to the E drive I would expect you would still hit permission problems.

    Is your resource database still not in the E...

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    is this windows 2008? could be UACL settings so talk to server admins.

    Make sure permissions on the directory on E are the same as the one on F, for the...

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    The Resource database metadata cannot be viewed by using the system catalog views or system tables.

    Another good reason to keep the resource database with the master in its default location.

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    SELECT name, physical_name AS CurrentLocation

    FROM sys.master_files

    WHERE database_id < 5

    ---------------------------------------------------------------------

  • RE: sql server 2000 upgrade in pplace to sql server 2008 r2

    yep, that looks to be the case, and then script out your server level objects.

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    p.s - I should clarify it is ok to move tempdb

    ---------------------------------------------------------------------

  • RE: Yet another question about the resource DB

    It is definitely a bad idea. It causes failures with patching if the master and resource databases are separate.

    Install your system databases where you want them as part of the...

    ---------------------------------------------------------------------

  • RE: sql server 2000 upgrade in pplace to sql server 2008 r2

    these are the available upgrade paths to SQL 2008 R2 -

    http://msdn.microsoft.com/en-us/library/ms143393.aspx

    do you meet one of these criteria, are you at SP4 for SQL2000?

    ---------------------------------------------------------------------

  • RE: Installing SQL Server 2008

    EjSQLme (4/8/2011)


    george sibbald (4/7/2011)


    what exactly do you want moved to the D drive? the system databases, all databases, or the binaries as well (e.g. the binn directory)

    I want to move...

    ---------------------------------------------------------------------

  • RE: SAN backups of databases?

    talk to your SAN vendor, get them to to tell you whether or not they guarantee database consistency. If they won't, don't rely on it for DR or HA.

    ---------------------------------------------------------------------

  • RE: Installing SQL Server 2008

    what exactly do you want moved to the D drive? the system databases, all databases, or the binaries as well (e.g. the binn directory)

    ---------------------------------------------------------------------

  • RE: SAN backups of databases?

    I cannot speak for all SAN replication technologies but one would hope they are all transactionally aware else they are useless for database purposes and should only be used on...

    ---------------------------------------------------------------------

Viewing 15 posts - 1,846 through 1,860 (of 4,745 total)