Viewing 15 posts - 1,846 through 1,860 (of 4,745 total)
join sysdatabases to sysaltfiles on dbid (in master database)
April 13, 2011 at 4:16 pm
then you should be fine, just don't drop them.
same IP addresses?
April 13, 2011 at 3:51 pm
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...
April 13, 2011 at 3:39 pm
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...
April 12, 2011 at 4:02 pm
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...
April 12, 2011 at 1:46 pm
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.
April 12, 2011 at 1:15 pm
SELECT name, physical_name AS CurrentLocation
FROM sys.master_files
WHERE database_id < 5
April 12, 2011 at 1:12 pm
yep, that looks to be the case, and then script out your server level objects.
April 12, 2011 at 1:06 pm
p.s - I should clarify it is ok to move tempdb
April 12, 2011 at 10:12 am
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...
April 12, 2011 at 10:11 am
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?
April 11, 2011 at 4:04 pm
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...
April 8, 2011 at 7:48 am
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.
April 8, 2011 at 5:10 am
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)
April 7, 2011 at 4:56 pm
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...
April 7, 2011 at 4:47 pm
Viewing 15 posts - 1,846 through 1,860 (of 4,745 total)