Viewing 15 posts - 4,276 through 4,290 (of 9,241 total)
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
you need to move the folder contents under the folder path that contains the file stream data. Check books online for more info on the alter database command
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2013 at 8:04 am
why do you want to log ship between 2000 and 2008, do you understand the ramifications of doing this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2013 at 10:04 am
Simha24 (2/15/2013)
I am going to implement log shipping between 2000 (primary ) and 2008 R2 (secondary).
Why???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2013 at 9:56 am
Viewing 15 posts - 4,276 through 4,290 (of 9,241 total)