Viewing 15 posts - 8,146 through 8,160 (of 9,244 total)
starterm (3/25/2010)
How do you make failure in primary server instance
Pull the network cable out!!!!
starterm (3/25/2010)
and make secondary server instance databases onlineplease provide your suggestions..
To bring secondary databases online, restore any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2010 at 3:38 am
No problem, glad i could help!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 25, 2010 at 7:16 am
river1 (3/24/2010)
ok, thank you very much.So what is the "EXECUTE AS" for?
to execute as another database user that is not linked to a server level login
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:13 pm
test the SP3 first on a test sql server to make sure it doesnt break anything!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:09 pm
river1 (3/24/2010)
I need to know where (in wich database) to create the login and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 12:06 pm
if you script this yourself just remember to disable or remove any foreign keys, triggers, etc first. Create the base schema (Tables) and load all the data then apply any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:51 am
Ratheesh.K.Nair (3/24/2010)
Hi Experts,Is it possible to take a table level backup?
TIA
Hi
if you want just data and structure then use the following for a quick and dirty
select * into newtable from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:44 am
if you run the root SETUP.exe it will detect your architecture and launch the appropriate installer. You can also see the architecture by clicking options on the left menu in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 24, 2010 at 11:37 am
is this a windows 2003 or windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 3:06 pm
Jeff Moden (3/22/2010)
It's a real shame that we have to try to rewrite that which works so well...[font="Arial Black"]Dir c:\*.* /s /b[/font]
Good old DOS Jeff, you can't beat it can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 11:56 am
Scott Wise (3/22/2010)
Perry,I really appreciate the follow up. Isn't what you are saying to do just creating a new cluster?
No, it is creating a new clustered instance 😉
there is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2010 at 10:40 am
newbie2sql (3/19/2010)
Solution you had given me is correct for my solution. Currently I am checking the permissions and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2010 at 4:19 am
yes, that goes without saying!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2010 at 4:16 am
OK, i made this real easy. The screenshots below shows the registry entries created when installing SQL Server and the instance configuration in the installer. Notice the default instance (MSSQLSERVER)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:45 pm
i dont see whats wrong with my script?? :ermm:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2010 at 6:31 pm
Viewing 15 posts - 8,146 through 8,160 (of 9,244 total)