Viewing 15 posts - 4,276 through 4,290 (of 9,244 total)
Rade_ (2/21/2013)
USE DATABASE
GO
select'CREATE LOGIN ' + sl.name +
' WITH PASSWORD = ' +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2013 at 5:13 am
it doesnt matter, 2nd approach is probably easier and would be the way i would do it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2013 at 5:11 am
have you tried the Redgate forums or just raise a support call and ask the Redgate support desk, they're very helpful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 8:16 am
Its easy, first setup a table in your DBA util database listing the nodes and the preferred location of any instances.
Just use
select serverproperty('computernamephysicalnetbios')
in your audit job and it will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 7:50 am
Ensure the name is 15 chars or less
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 7:47 am
The users have to be disconnected for the log restores to take place. The database engine is just deferring this action until users are clear, this from Books Online
SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 7:47 am
Ed Wagner (2/21/2013)
I just love the wide variety of stuff available...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 7:33 am
m.rajesh.uk (2/20/2013)
Windows NT group/user 'NT SERVICE\MSSQLSERVER',
It's not a group, its a virtual alias used by the service account in SID based security when using SQL Server 2008 under Windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 21, 2013 at 7:25 am
Whatever happens you will need to release the sql server handles on the disk file(s), what capacity do you have to copy 200gb of database files across the drives? You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2013 at 11:15 am
happycat59 (2/17/2013)
Database mappings are actually relationships between the syslogins table in the master database and sysusers table in the user database.
Note that the correct catalogs now are
sys.server_principals for server level...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2013 at 2:23 am
Can you supply more info about how the storage is mapped, it seems to be mapped as one large disk group. The group doesn't contain a disk small enough for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2013 at 1:41 am
what do you see under "Available storage" in the Failover Cluster manager snap in?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2013 at 9:26 am
EdVassie (2/18/2013)
the best thing is to open a Support Case with Microsoft.
or hire a consultant to troubleshoot the system for you, which would likely be a lot cheaper than calling...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2013 at 9:25 am
Can you post a screenshot of what you see?
To check the settings for a log shipped database use the following
against the primary
exec sp_help_log_shipping_primary_database 'primarydb'
against the secondary
exec sp_help_log_shipping_secondary_database 'secondarydb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2013 at 9:18 am
What operating system is the cluster using Windows 2003 or Windows 2008?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2013 at 9:07 am
Viewing 15 posts - 4,276 through 4,290 (of 9,244 total)