Viewing 15 posts - 826 through 840 (of 4,745 total)
SQLRNNR (1/21/2013)
george sibbald (1/21/2013)
Hey! 5000 points! Maybe enough to be listened to now! 🙂Congrats
thanks Jason.
OP, post your exact code whem moving the resource database please.
---------------------------------------------------------------------
January 21, 2013 at 9:46 am
jfriedl (1/21/2013)
I was hoping I wouldnt have to do that, does MS have any best practices for where the binaries and dll files should be installed?
not on the system...
---------------------------------------------------------------------
January 21, 2013 at 9:33 am
the installation Path can be anywhere, some parts of the install will always end up on the C drive though.
---------------------------------------------------------------------
January 21, 2013 at 9:31 am
odd how the resource database is not listed in sysaltfiles in SQL2005 but it is in SQL2008 (and SQL2008R2). Is this view present in SQL2012?
MSSQLSystemresource is not listed in sys.master_files.
quite...
---------------------------------------------------------------------
January 21, 2013 at 4:54 am
[Why are you moving the system databases, what are you trying to achieve? -- We need to replaced the drives where all the System DB are placed.
could...
---------------------------------------------------------------------
January 20, 2013 at 3:22 pm
did you follow this process when moving the system databases? -
http://msdn.microsoft.com/en-us/library/ms345408(v=sql.90).aspx
the mssqlsystemresource database is a read only database microsoft do not want you to manipulate, so it does not appear...
---------------------------------------------------------------------
January 20, 2013 at 12:50 pm
I'd agree with that, which is why I put in the caveat of managing expectations. There are definitely times you have to lay down the law and to hell with...
---------------------------------------------------------------------
January 18, 2013 at 10:29 am
might be getting bogged down in the term 'nice' here. I don't think they have to be nice either and DBAs should certainly never be pushovers, but they have to...
---------------------------------------------------------------------
January 18, 2013 at 10:04 am
this should have all you want
http://support.microsoft.com/kb/958734
---------------------------------------------------------------------
January 18, 2013 at 6:24 am
TravisDBA (1/17/2013)
lewandot (1/17/2013)
---------------------------------------------------------------------
January 17, 2013 at 10:27 am
monitor erorlogs
monitor sqlagent jobs
ensure your backups are actually happening (dont just monitor for failure)
test your DR procedures from time to time
---------------------------------------------------------------------
January 17, 2013 at 10:04 am
-- set compatibility level
-- change dbowner to same as it was under SQL 2000, it is usually 'sa', but check
-- update all statistics, needed for performance, SQL 2005 interprets these...
---------------------------------------------------------------------
January 17, 2013 at 7:18 am
if its deleting one at a time dont expect problems with the log but it will run slowly.
---------------------------------------------------------------------
January 16, 2013 at 8:08 am
Ratheesh.K.Nair (1/15/2013)
---------------------------------------------------------------------
January 16, 2013 at 4:24 am
Lynn Pettis (1/15/2013)
george sibbald (1/15/2013)
sjimmo (1/15/2013)
Lynn
To restore to 1/13 4:00 AM you will need the previous days (1/12) full backup file plus all the t-log backups since that backup up...
---------------------------------------------------------------------
January 15, 2013 at 1:10 pm
Viewing 15 posts - 826 through 840 (of 4,745 total)