Viewing 15 posts - 3,196 through 3,210 (of 9,244 total)
Jeff Moden (7/1/2014)
I believe that if you simply add another file to the file group, it will use that new file until both files balance.
Unless the first file is full,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 4:28 am
Sean Lange (6/30/2014)
Craig G (6/30/2014)
2. sorry on second question,its .NDF file not .LDF .Pretty sure you mean MDF unless you use your own extensions.
No, a secondary database file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 4:23 am
miaka102 (6/30/2014)
I am trying to set up a log shipping in my primary db server, then I encounter this error messages,"Error: Logon failure: unknown user name or bad password".
At exactly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 4:18 am
smallmoney (6/30/2014)
I been trying to learn availability groups since I have not implemented it.
Check my article at these links for more info
smallmoney (6/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2014 at 4:13 am
Grant Fritchey (6/30/2014)
As long as you have unique file names on a given server,
It's not the server dictating this. You can have 100 databases all with the primary filename bob.mdf,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 8:40 am
Chowdary's (6/30/2014)
but without changing the names is there any chances?
If you change the folder path then yes.
I'm assuming you understand the concept of files and folders within a filesystem???
The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 7:29 am
Chowdary's (6/30/2014)
As i am using the Same system it may creates some problem i agree with you,
But i had checked in other system which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 5:58 am
Chowdary's (6/30/2014)
Am using 2008 and 2012 in my System.
I have Question like the following.
In 2008 i have taken the Full backup and can restored that Backup into the New...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 5:48 am
EdVassie (6/30/2014)
The only way forward for your log shipping is to switch back to Full and send a new full backup to reinitialise log shipping.
This is not entirely accurate, if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 5:19 am
Bipsy (6/29/2014)
What exactly is a core differences between master database in SQL 2012 cluster instance and SQL 2012 standalone instance.Is master DB in SQL cluster instance holds any info...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2014 at 4:42 am
tcronin 95651 (6/26/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2014 at 1:54 pm
Can you post a screen shot of the tcpip settings dialog in configuration manager
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2014 at 5:16 pm
kevinsql7 (6/26/2014)
I am also wondering if all three of these method (backup/restore, detach/attach, & copy database wizard) would automatically perform a database upgrade? For instance, if you are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2014 at 8:02 am
No problem, as i said switch to bulk logged for the rebuild and you wont break the log chain, but the rebuild will still be minimally logged
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 27, 2014 at 3:59 am
jitendra.padhiyar (6/24/2014)
I am able to installed DTC. It was timezone issue. I set correct time zone and it works.
Now I face new issue.. I installed MSSQL Server 2008 R2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 26, 2014 at 9:07 am
Viewing 15 posts - 3,196 through 3,210 (of 9,244 total)