Viewing 15 posts - 5,686 through 5,700 (of 9,241 total)
balasach82 (4/16/2012)
.................ALTER DATABASE tempdb
ADD FILE (NAME = tempdev2, SIZE = 200, FILENAME = 'D:\\...\tempdb2.mdf');
GO
.................
......................one LDF file
Do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 7:17 am
Perry Whittle (4/15/2012)
You said you restored the database back to the same server as the original and didn't have to re create any logins???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 6:57 am
Cool, no problem.
Like I said though, in my experience i'm dealing with an instance of SQL Server where i am not only adding files but also reconfiguring the primary file,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 5:00 am
Are the objects in a separate schema, i.e. not dbo?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 4:17 am
balasach82 (4/15/2012)
I had settled for Gail's view that SQL restart is not required after tempdb division. Perry recommends a restart for the algorithm (for which the tempdb is being divided)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2012 at 12:32 am
jim.hamer (4/15/2012)
Perry, I ranexec sp_change_users_login 'report'
but it returned nothing.
Are you sure you set the correct database focus for the query window, you didn't run it in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 11:55 pm
jim.hamer (4/15/2012)
so I had to create a new user that is local to the test server.
You said you restored the database back to the same server as the original and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 11:51 pm
balasach82 (4/14/2012)
1. After dividing the tempdb into "n" number of files, do we need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 3:01 pm
cc 49739 (4/15/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 2:49 pm
You moved a copy of the database, what did you do about the logins that access the database did you transfer these too?
Open a new query window against the newly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 2:24 pm
Hbruce (4/15/2012)
The remote site users are experiancing long delays in accessing data (Due to the large size of the database) from the main site.
The size of he database has absolutely...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 10:37 am
pawan_amity (4/15/2012)
Ho w I can have sql server 2008 R2 cluster installation guide on vmware?
Send me your email address and I'll send you my guide
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2012 at 5:35 am
Hbruce (4/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2012 at 8:47 pm
Why aren't you using .net roles and authorisation it has all you need for this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 14, 2012 at 8:36 pm
Log shipping would work, you just need to make sure that the administrator at the time of any failure is well versed at bringing SQL server databases online and general...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2012 at 12:36 pm
Viewing 15 posts - 5,686 through 5,700 (of 9,241 total)