Viewing 15 posts - 9,106 through 9,120 (of 9,241 total)
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
use
CREATE LOGIN prova WITH PASSWORD = 'prova123prova'
my guess is the password is not being recognised
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:48 pm
you could use a trusted connection or a file DSN
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:37 pm
we have a few SQL VM's in our enterprise, personally unless there was a drastic need i would prefer to do a fresh build of the SQL server and migrate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:15 pm
Viewing 15 posts - 9,106 through 9,120 (of 9,241 total)