Viewing 15 posts - 16 through 30 (of 82 total)
Hi Swwg
When i tried to migrate it by using Export import tool, i got the same prob,
I couldnt get the whole schema as it was in source, so i tried...
September 5, 2013 at 7:21 am
That works OK for tiny databases. Over a couple hundred MB, that generally crashes Management Studio.
Ok thats a TIP....
I will remember that....
Thank u Gail
September 4, 2013 at 1:29 pm
Hi Guys,
i have just finished with copying the DB from 2012 to 2008r2,
'
i chose a hard and lengthy method other than Gail recomended,
But i would say +1 for gail,
I generated...
September 4, 2013 at 1:26 pm
Hi Gail,
I generated the scripts and executing the query already,
I will follow your whole idea and let you know
September 4, 2013 at 12:47 pm
GilaMonster (8/30/2013)
You could, but why would you want to? Restoring a backup's going to be faster and less work.
Just want to know....
thanks
i am still a Rookie :hehe:
August 30, 2013 at 9:26 am
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.
Hi Perry
a quick doubt
Can we use Export import...
August 30, 2013 at 9:18 am
I assume there must be some process to run to resync the servers before failing back.
Always On High Availability does mean they are always synchronized on all...
August 30, 2013 at 8:34 am
Is failback exactly the same as failover?
i can comment on this statement..
Failover and Failback are two different kind of "Procedures"
They are same...
While assiging High Availability groups, You choose one...
August 30, 2013 at 8:24 am
I will sure follow the sugestion
Anyway thank you guys for the support,
Any ideas can be further posted...
I would try to post the solution as soon as i find it
August 29, 2013 at 1:56 pm
Talib123 (8/29/2013)
Is the folder (WINDOWS FOLDER for SQL agent) accessible by the account running the...
August 29, 2013 at 11:26 am
Have you check Windows Event Log if there is any clue? (There rarely is, but...)
Please confirm that you used SQL Server Configuration Manager to set the service account.
Yes i checked...
August 29, 2013 at 6:12 am
SQLAli (8/28/2013)
1) Check the error log.
2) We can see few errors in SQLAgent.out
3) Check whether Agent XP is...
August 28, 2013 at 11:27 am
Erland Sommarskog (8/27/2013)
rajborntodare (8/27/2013)
this organization installs every instance on D drive. the same path is with D drive
something like this
\D:\Program Files\Microsoft SQL Server\MSSQL11.AGOSQL2K12DEV01\MSSQL\Log\SQLAGENT.OUT
Yes, is there a LOG directory? And...
August 28, 2013 at 7:22 am
Erland Sommarskog (8/27/2013)
In such case, does it include anything interesting?
Note that the exact path varies depending on your installation. The above assumes...
August 27, 2013 at 6:36 am
Are you giving the service account username and password correctly?.
Yes i am sure they are correct
August 27, 2013 at 6:30 am
Viewing 15 posts - 16 through 30 (of 82 total)