Viewing 15 posts - 8,386 through 8,400 (of 9,244 total)
read the MS recommendations.
http://support.microsoft.com/kb/280345
certainly no larger than 1GB should be required but recommended is 512MB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2009 at 4:00 am
the biggest problem is setting the shared storage and this is what i think most people stumble on. The storage can only be accessed by one VM at a time...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2009 at 2:45 pm
Anybody?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2009 at 3:52 am
anuragingle (2/19/2009)
I added the user to db_datareader and gave him execute rights on specified sp......... seems to be working
yes it would do, you dont need to give db_datareader and it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2009 at 3:26 am
personally i would use
1. Backup the databases in Sql server 2000.
2. Script the logins,jobs in sql 2000
3. Install sql server 2005, SP3, sqlserver2005_dts.msi
4. Restore the backups in newly installed sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 4:54 pm
anuragingle (2/19/2009)
Will stored procedure execution fail if user has only read rights on database?Is it possible to implement this and how?
granting execute on a stored procedure to a user does...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 4:45 pm
drop the auto created stats from the sql2000 prod database, otherwise each time you restore that db the corrupted object will still be there,
does this make sense
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 4:41 pm
Kendal i too, did notice the graphs were a little off but paid more attention to the actual numbers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 4:38 pm
Matt Klein (2/19/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 4:36 pm
either backup and restore or detach and attach to the new server. Script off the login if possible or create a new server login on the sql 2005 server and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 3:17 pm
depends what you're going to need. Windows 2003 Std x64 bit is limited to 32GB RAM and 4 cpus.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 3:11 pm
1434 udp is only required if not connecting to the named instance directly and usually if the instance is using the non standard port 1433
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 2:59 pm
are all the datafiles in separate filegroups?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 11:31 am
Great blog Kendal (you have way too much time on your hands 😀 )
very informative
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 19, 2009 at 11:19 am
Jack Corbett (2/18/2009)
you could restrict the query to only access the most current file which would reduce impact.
filter out tempdb objects too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2009 at 2:50 pm
Viewing 15 posts - 8,386 through 8,400 (of 9,244 total)