Viewing 15 posts - 3,556 through 3,570 (of 9,241 total)
ramyours2003 (2/13/2014)
how to bring the sql services in to offline in a cluseter , naviagte procedure to tak to offline/onlnie ?
via a command prompt on the Windows 2008 cluster node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 9:08 am
wodom (2/13/2014)
For years it has always appeared to me that the fastest/easiest way to migrate is a backup/restore across the network,
To a certain point, if the database is not required...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 5:17 am
do you have another mlocation where you can test restore the backup files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 4:12 am
Jake Shelton (2/14/2014)
We are migrating to a new server, of course we are splitting out log and datafiles, but otherwise, any best practice on folder naming?
We were thinking of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 3:21 am
restoring over a network is just as bad, why do you think the copy job moves the files locally to the secondary instance 😉
Fo you have any other errors, etc...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 3:19 am
If you really want to move the database and put in standby mode using a backup you'll need to perform the following on the source server
RESTORE DATABASE yourdb WITH RECOVERY[/CODE]
BACKUP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 2:58 am
SQLb2t (2/14/2014)
I dosent work even after specifying restore file path same as backup location.means I am picking same backup file
I think you're misunderstanding what i am asking.
Log shipping has a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 2:34 am
Have you checked the disk integrity where the log backups are moved to on the secondary server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 14, 2014 at 1:53 am
You're welcome 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 5:00 pm
Ravid_ds (1/31/2014)
This could be a laymans query, please help.
We are planning to move a StandBy/Readonly mode Database to a new server. This DB is not configured for log shipping....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 4:56 pm
Brad Scheepers (2/11/2014)
ALTER DATABASE myDatabase SET offline
ALTER DATABASE myDatabase MODIFY FILE (name=myDB_filename, FILENAME='X:\New_Path\myDatabase.mdf')
ALTER DATABASE myDatabase MODIFY FILE (name=myDB_logname, FILENAME='X:\New_Path\myDatabase_log.ldf')
** Physically move the files at this point to their new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 4:55 pm
The differential base lsn results indicate that since you restored the full backup from prod another backup had been taken against prod, @ 1pm on the 13/02 to be exact....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 12:04 pm
No, listeners are per availablility group. Don't confuse the AO listener with Oracle listeners
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 7:32 am
TerrenceTheCat (2/13/2014)
Thank you so much for your help. Below is the output from the query you asked me to execute
(No column name)name ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 7:07 am
muthyala_51 (2/12/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2014 at 6:30 am
Viewing 15 posts - 3,556 through 3,570 (of 9,241 total)