Viewing 15 posts - 5,791 through 5,805 (of 9,244 total)
wayne.mcdaniel (3/30/2012)
- get the physical file names and locations
- put the database in single user mode
-...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2012 at 4:02 pm
You shouldn't need to set the database single user first, just issue the following
alter database set offline with rollback immediate
[/Code]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2012 at 1:10 am
Agreed, use the backup.sqlbackup method via SMO. You'll also be able to display a nice little progress bar too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2012 at 12:57 am
MiguelSQL (3/28/2012)
I have a two node Windows 2008 cluster, for which I'm running two instances of MS SQL 2008 R2 SP1 64 Bit Enterprise Edition in an active/active configuration.
Customer wants...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2012 at 12:11 pm
SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queries
use the stored procedure xp_logininfo
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2012 at 2:44 pm
to change the instance name you would have to install a new instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 28, 2012 at 2:36 pm
SQL_Helper (3/27/2012)
Greate, thanks for the response.
I am expanding this discussion 1 step further.
Now we have 3 nodes cluster (2 active and 1 passive), Please help to answer following queries.
Requirement:
==========
a) I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2012 at 10:24 am
In addition to Jeffrey's comments you may also query the table msdb.dbo.backupfile, this will detail the logical and physical filenames for the databases that were part of a backup operation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2012 at 6:46 am
Lynn Pettis (3/14/2012)
Windows Server 2003 R2 on 32 bit servers only supports 4GB ram.
Standard edition yes, Enterprise and above have a much higher memory limit
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2012 at 6:30 am
gmamata7 (3/16/2012)
Sorry Perry,Can you please tell me how to do the same in 2008?
Create a new post in the following forum and i'll post details for you 😉
http://www.sqlservercentral.com/Forums/Forum1632-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2012 at 7:00 am
Check the windows firewall on each node and whether you have a network firewall device between the nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2012 at 6:54 am
have you checked and verified the mirroring endpoint configurations, this is undoubtedly where your problem will be
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2012 at 6:52 am
The process is exactly the same for any SP or CU update for SQL Server 2008 onwards.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2012 at 1:44 am
THE-FHA (3/23/2012)
I am not installing on VM, i am using physical machines running windows 2008 R2 and SQL 2008 R2.
If i want to slipstream 2008 R2 where can i get...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2012 at 12:52 am
bijarcity(Ehsan Akbar) (3/20/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2012 at 4:52 pm
Viewing 15 posts - 5,791 through 5,805 (of 9,244 total)