Viewing 15 posts - 8,686 through 8,700 (of 9,241 total)
how big is the database?
you could use SQLExpress 2005 if its under 4GB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 12:44 am
from BOL
Logical and Physical File Names
SQL Server 2005 files have two names:
logical_file_name
The logical_file_name is the name used to refer to the physical file in all Transact-SQL statements. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:32 pm
the logical filename is generally used internally by SQL server, changing it to something different after copying the database is something i would defintiely do.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:07 pm
i would re apply SP2 in this case
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:06 pm
Niyala (12/4/2008)
Because it would be much easier for me than adding individual members manually and, therefore, I wanted to import the Builtin\adminstrators.
Alternatively, I wanted to create a login for a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:46 am
its more to do with admin rights on the box, put yourself in the administrators group on the server and watch the little green arrows appear 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:41 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:37 am
why would you want to allow any windows server admin access to sql server as an admin?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:28 am
anoop (12/4/2008)
Restore database Crew from disk = 'C:\SQL2005Backups\Crew\Full+1730.BAK'WITH move Crew to 'C:\SQL2005Backups\Crew.mdf',
move Crew_log to 'C:\SQL2005Backups\Crew.ldf'
my changes are in red, put single quotes around the logical filenames like...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:22 am
the empty white circles mean you can connect to sql server but you don't have rights to stop,start, restart the windows service(s) for that instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:14 am
clusters are either active\passive or active\active regardless of the number of nodes.
do you really need 50 instances? Remember that when a node fails the resources will be resumed on another...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 3:16 am
i take it that means you havent changed the account, could anybody else have access to do this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 3:12 pm
have you changed the account sql service runs under by any chance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 2:58 pm
clustering does not provide load balancing only fail over.
what is it you are looking to do specifically
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 1:17 pm
TheSQLGuru (12/3/2008)
2) IIRC Lock pages in memory is only useful for SQL Server Enterprise Edition.
this only applies to sql 64bit, its ok under 32bit
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 1:13 pm
Viewing 15 posts - 8,686 through 8,700 (of 9,241 total)