Viewing 15 posts - 5,011 through 5,025 (of 9,244 total)
SQLCrazyCertified (9/14/2012)
Perry Whittle (9/13/2012)
John Mitchell-245523 (9/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 7:30 am
i use a simple vb script, works for me
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 6:00 am
scogeb (9/13/2012)
What do you think about SAN LUNs? My storage guys here just gives me LUNs for each SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 2:16 am
scogeb (9/13/2012)
Maybe I'll start a new thread to discuss this. 🙂
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 2:12 am
alanspeckman (9/13/2012)
1. MS-DTC
2. SQL Server
And the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 2:04 am
go to the MCP site and check the regs there. Microsoft have very strict regs about the size and placement of the logo on letterheads and CVs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 2:02 am
For details of how a diff resumes an LS plan see the start of my article at this link
Humble pie anyone?????????? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 12:51 pm
Jeff Langdon (9/13/2012)
I set up Log Shipping from scratch, not taking a log backup and it worked like a charm.Thanks to everyone for your suggestions.
For the future, bear...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 11:49 am
the worst thing thats likely to happen is you type the wrong path\filename in the alter command. If you do then just re issue the correct command and the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 9:32 am
John Mitchell-245523 (9/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 9:18 am
Rob-350472 (9/13/2012)
perhaps I should think of going:shrink --> backup routine --> move...
no, use the method i showed you. backup and restore is a complete waste of time.
I use this method...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 9:16 am
Rob-350472 (9/13/2012)
Copy files in explorer from source to destination
right click --> 'bring online' (at a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 9:14 am
take a differential backup on the primary and restore it to the secondary to restart LS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 8:44 am
Rob-350472 (9/13/2012)
Need to wait till I can actually close Management Studio in the first place (and SQLserver process) to move the files first of all though!Thanks 🙂
No, you don't 😉
Issue...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 8:41 am
Rob-350472 (9/13/2012)
Besides a copy/paste of the files from location A to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 6:34 am
Viewing 15 posts - 5,011 through 5,025 (of 9,244 total)