Viewing 15 posts - 4,156 through 4,170 (of 9,241 total)
C:\Windows\system32>net start mssqlserver /f /m /t3608
The SQL Server (MSSQLSERVER) service is starting..
The SQL Server (MSSQLSERVER) service was started successfully.
Firstly don't start sql server as a service, also -f implies -m,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 9:01 am
You should at least understand the basics of TCP\IP networks, these are just some of the items you should have a basic understanding of IMHO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 1:15 am
You'll need to break the mirror session and restore the mirror database with recovery.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 12:03 am
Do you have another backup of model you can use?
If not grab a copy of model from another server with the same collation and version.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2013 at 12:00 am
Also, remember that a full backup will reset the page differential bitmaps and increment the Differential base LSN too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:32 am
are you using iSCSI attached storage and MPIO?
Can you provide a little more info on the storage and the connectivity from the nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:21 am
Can you provide a little more info on the storage itself and the connectivity to the storage from each node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2013 at 10:19 am
rcheneyjr (4/17/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 3:02 pm
You will likely need changes to your network infrastructure and shared storage infrastructure but you should be able to relocate the once you have the above sorted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 10:19 am
Whatever you use whether it be
Remember that server level objects such as logins, agent jobs, etc, etc need to be replicated...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 1:16 am
This thread is nearly 2 years old!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 12:32 am
A schema is used to collectively identify set objects, the schema can also be used to control permission lists defining access to the collective objects. Users create objects under schemas...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 22, 2013 at 12:06 am
You could also use
SELECT *
FROM sys.objects
WHERE is_ms_shipped<>1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2013 at 8:05 am
vishalsurya50 (4/19/2013)
In sql server 2012 creating a cluster , i had added servers and the next step is Access point for administering the cluster which i need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2013 at 7:48 am
Have you checked the maintenance plan history?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2013 at 10:09 am
Viewing 15 posts - 4,156 through 4,170 (of 9,241 total)