Viewing 15 posts - 466 through 480 (of 4,745 total)
pausing not strictly necessary but yes those are the steps. Take a log backup just before you start.
The log of the primary will fill whilst the secondary is down so...
October 15, 2013 at 7:50 am
alanspeckman (10/4/2013)
October 9, 2013 at 3:56 pm
I don't need it broken down and if you check back I am not the OP in this thread, so I don't have a problem I need advice on.
I seem...
October 9, 2013 at 12:36 pm
is the log backup job running successfully?
October 9, 2013 at 12:14 pm
it suggests your log backup job is failing. Have you done an initial full backup? Is the database still in full or bulk logged recovery mode?
October 9, 2013 at 11:40 am
Hi, what do you mean by mapping? Yes that script will tie the logins to the users in the databases because it brings the sids over, i.e. they are mapped...
October 9, 2013 at 11:36 am
It's the Database!!! (10/8/2013)
PearlJammer1 (10/7/2013)
It works with 2008 as well, I used it.
Are you sure that it also mapped the users database access and permissions ? When i run the...
October 8, 2013 at 7:33 am
that script only gives the logins, sids and passwords, plus default database.
The user permissions would only come across if you copied the databases over. As you are not you need...
October 7, 2013 at 2:56 pm
well if it does not I guess that is a good thing. 🙂
All I can think of is to run dbcc proccache immediately before and after or run profiler with...
October 7, 2013 at 2:49 pm
did you get the message 'SQL Server has encountered %d occurrence(s) of cachestore flush for the '%s' cachestore (part of plan cache) due to some database maintenance or reconfigure operations"....
October 7, 2013 at 2:33 pm
are you transferring the databases as well, because this should retain the login\user mappings. Please describe your full process.
October 7, 2013 at 12:39 pm
don't shrink it, it will just grow again on the next reindex. Either back the log up more frequently, put the database in bulk logged mode during the reindex or...
October 7, 2013 at 6:35 am
I am no VMware expert and may have the terminology wrong but you can definitely vmotion(?) or bring up a virtual server in another location with the same ip address,...
September 28, 2013 at 12:55 pm
Also run these
alter database dbname set page_verify checksum -- torn_page_detection
-- upgrade creates a schema for all users and sets this as default, use following to create SQL to
-- modify users...
September 27, 2013 at 10:34 am
It's the Database!!! (9/26/2013)
September 26, 2013 at 3:41 pm
Viewing 15 posts - 466 through 480 (of 4,745 total)