Viewing 15 posts - 8,326 through 8,340 (of 9,241 total)
Venki
you didnt indicate in your first post that the backup was a sql2005 database going into sql2000. This cannot be done. Only option is to DTS the data across to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2009 at 6:23 am
mixed mode does help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2009 at 1:22 pm
if you are not sure what you are doing i would leave well alone (and i mean that in the nicest way possible). Bring the cluster down and you could...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2009 at 10:30 am
The problem is (and i have come across this before) if you do point out a dev's bad piece of code mostly they get uptight, jumpy and defensive instead...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2009 at 10:29 am
Paul
what Jeff is saying (and you have to agree is quite correct),You shouldnt do it expecting a massive increase in performance otherwise you could well be dis appointed. There are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2009 at 5:46 am
if its a VM and you have the OS licence, may as well install 64 bit. As a VM you can scale memory, cpu and disk when required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2009 at 7:26 am
here you go, courtesy of uncle Bill
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2009 at 3:24 pm
what version vmware server you using?
have you mapped your VM's virtual NIC to the physical network or to a private virtual network, double check your config
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2009 at 3:14 pm
you didnt get the job then?
full filegroup backup is different to full database backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2009 at 3:10 pm
Ryan Wellman (5/16/2007)
I changed the "log on as" to .\Administrator for SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER). In the SQL Server Configuration Manager and ran the Log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2009 at 2:54 am
the application will generally just issue statements to the database. What can cause problems is 32 bit versions of sql server interracting with 64 bit versions, replication in particular is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 5:03 pm
Dave (3/10/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 4:17 pm
if the server login exists and the database user exists in the database you only need to use
exec sp_change_users_login 'Update_One', 'Current user in DB', 'SQL login to link to'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 4:10 pm
xgcmcbain (3/11/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 3:13 pm
queries are only a small part of what sits in RAM, you have the buffer pool too which comprises all the database pages read from disk to memory for modifying....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 12:56 pm
Viewing 15 posts - 8,326 through 8,340 (of 9,241 total)