Viewing 15 posts - 4,291 through 4,305 (of 9,244 total)
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
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
Viewing 15 posts - 4,291 through 4,305 (of 9,244 total)