Viewing 15 posts - 31 through 45 (of 388 total)
GilaMonster (3/15/2010)
GTR (3/15/2010)
Have Server guys Disable IIS on Application Servers...
Enable IIS on on application servers.
Um, what?
Because don't want any connections through applications to database server during migration window.
March 15, 2010 at 3:43 pm
If you want migrate to SQL 2008 on same server then, probably your approach is correct. Only thing is you don't have good backout plan, if you have to fail...
March 15, 2010 at 3:18 pm
I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be on IP1 and IP2, but the Cluster Service runs on IP3; if the server on...
March 15, 2010 at 2:04 pm
Jason and Lowell had already referred very good articles, here is few more for SQL 2008 cluster install though it SQL 2008 the concept is same for cluster.
http://www.mssqltips.com/tip.asp?tip=1687
http://www.mssqltips.com/tip.asp?tip=1698
March 15, 2010 at 1:59 pm
Are you moving only few databases or migrating server?
March 15, 2010 at 1:47 pm
Jon Russell (3/15/2010)
GTR (3/15/2010)
Jon Russell (3/15/2010)
GTR - Yes, it is working now. Thanks.Just curious, what did you change?
Take a look at my reply to Jeffery.
Sorry, too much lunch:-)
March 15, 2010 at 1:44 pm
CirquedeSQLeil (3/15/2010)
Molly Cary (3/15/2010)
Great! thanks. I am seeing that it's happening around 2-3 am.Do you by chance have an index rebuild job scheduled at that time?
Yes, Index rebuild will grow...
March 15, 2010 at 1:42 pm
Jon Russell (3/15/2010)
GTR - Yes, it is working now. Thanks.
Just curious, what did you change?
March 15, 2010 at 1:33 pm
Can you run this query now and post the result here?
SELECT name, state_desc from sys.databases
March 15, 2010 at 1:27 pm
Jon Russell (3/15/2010)
GTR - Even though I already tried your suggestion, it turns out you where correct about it being a permissions problem. Thank you.
Is it working now?
March 15, 2010 at 1:11 pm
reddy-442519 (3/15/2010)
Hi,There is any native or third part tools to manage multiple sql server's instance's running on multiple servers. Ex. Oracle Enterprize Manager.
Thanks in Advance.
Thanks!
Reddy
You can you SSMS to...
March 15, 2010 at 11:03 am
CirquedeSQLeil (3/15/2010)
What versions of SQL Server? What kind of environment (clustered, replication)?A little more information might be helpful.
And is it complete server migration? or just few databases? how big...
March 15, 2010 at 10:57 am
Adding to Steve questions, Did you try to find out what causing TempDB to grow?
March 15, 2010 at 10:54 am
GilaMonster (3/15/2010)
Bad idea. Using the profiler GUI at all on a production server is a bad idea.http://scarydba.wordpress.com/2008/12/18/profiler-research/
http://scarydba.wordpress.com/2009/10/28/snags-with-profiler-gui/
Rather use the server-side trace and save the trace to a fast local drive.
Agreed.
March 15, 2010 at 10:34 am
Check the jobs and see what is the back up files path for the jobs, can you post the failing jobs error message here?
March 15, 2010 at 10:28 am
Viewing 15 posts - 31 through 45 (of 388 total)