Viewing 15 posts - 4,291 through 4,305 (of 9,241 total)
MissTippsInOz (2/14/2013)
However I did, and still believe its necessary
The idea is to keep the 2 way configuration in place as the document states.
From the error it sounds like an agent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2013 at 4:17 pm
The link I posted does not tell you to run sp_delete_log_shipping_primary_secondary or sp_delete_log_shipping_primary_database for the role reversal!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2013 at 3:51 pm
balasach82 (2/14/2013)
My database is already populate, its 523gb now.1. Can I create new files in new drive but in Primary filegroup
If the database and its primary filegroup is already at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2013 at 6:07 am
sumith1andonly1 (2/13/2013)
GOT ERROR : "User does not have permission to create database".
Then i tried to enable 'sa' account.but it also...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2013 at 2:26 am
MissTippsInOz (2/13/2013)
I'm currently running some DR testing and have failed over a couple of databases to our DR site. Generally the process was:
Tail log backup on ServerA with NORECOVERY
RESTORE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2013 at 2:23 am
No but since the database id may change history would be lost here
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 4:21 pm
Jason Shadonix (2/13/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 3:13 pm
I'm not being snarky that comment is a subtle hint.
The old
EXEC sp_attach_db @dbname = N'AdventureWorks2012', @filename1 =
N'C:\Somepath\AdventureWorks2012_Data.mdf', @filename2 =
N'C:\Somepath\AdventureWorks2012_log.ldf';
The new
CREATE DATABASE database_name
ON PRIMARY (name=mydb_data, filename='d:\somepath\mydbdata.mdf')
LOG ON (name=mydb_log,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 2:01 pm
Jason Shadonix (2/13/2013)
You're joking right? Create and alter database have been enhanced extensively to include extra commands (file management, mirroring,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 12:56 pm
balasach82 (2/13/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 12:29 pm
Jason Shadonix (2/12/2013)
Question - What advantages does this method have over the detatch/reattach method of moving files around?
It's the supported way of moving database files and doesn't involve dropping the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 9:07 am
balasach82 (2/12/2013)
Database_Data.mdf
Database_1.ndf
Database_2.ndf
Database_3.ndf
Database_4.ndf
Database_log.ldf
I have decided on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 8:18 am
Check the output of the following query for top consuming tables and post their names
USE msdb
GO
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 6:18 am
The issue only seems to be affecting local disks too, all my windows 2012\sql server 2012 VMs are on ESX5.1 and are using iSCSI disks not VMWare virtual disks. I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2013 at 6:13 am
kevaburg (2/12/2013)
Although this is a very good article with regards to moving user databases
That is exactly what it is targeted at!
kevaburg (2/12/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2013 at 8:47 am
Viewing 15 posts - 4,291 through 4,305 (of 9,241 total)