Viewing 15 posts - 9,106 through 9,120 (of 9,244 total)
Jason Shadonix (7/23/2008)
Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 10:56 am
sorry my bad!!
restore database DBNAME with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 10:31 am
re run the SQL installer it should pick up any instances already on the pc, then run repair
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 9:18 am
when the database is in the restoring state try the following command and see if the database comes back online
alter database mydata with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 9:13 am
no need to shutdown sql instance,
just set the database offline. Once this is done you can then move the disk file.
After you copied the file to its new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 9:00 am
Max Databases per instance of SQL Server = 32,767
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 8:55 am
what are the preceding errors?
open up the plan and double check it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 5:27 am
you do need to assign the user account sql runs as to the local policy "lock pages in memory"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 5:23 am
how much RAM does the server have?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 1:51 am
did you format using the 64k switch?
was it successful?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2008 at 1:50 am
your welcome m8tey
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 3:02 pm
what version ESX server are you using out of interest?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 2:52 pm
how many disks are in the array that the file sits on?
also what is the set up of sql server, where are the data and log files stored?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 2:39 pm
in linked table manager when the login box appears use trusted connection
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 2:38 pm
can you not just take a backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:50 pm
Viewing 15 posts - 9,106 through 9,120 (of 9,244 total)