Viewing 15 posts - 8,266 through 8,280 (of 9,241 total)
Krishna Potlakayala (3/28/2009)
You can't copy the .mdf file if the server is online.
"Au contrair mon pere"
you dont need to shutdown sql server!
you dont need to detach the database!
you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 6:39 am
Achtang (4/7/2009)
I want to configure cluster and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 5:31 am
use the alter index command, this is also minimally logged under bulk-logged and i think simple recovery too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 5:12 am
y.koteswarrao (4/8/2009)
Yes we are using log shippingThanks
Koteswar Rao.Y
in that case the posts above by Markus and myself are sufficient enough to help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 5:07 am
SQL Noob (4/7/2009)
they give you a bare bones management GUI, but none of the good features.
you can use the VI client for a complete VI or for a single...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2009 at 8:52 am
incidentally, if it is log shipping and you dont have any further backups to restore but want to bring online simply issue
RESTORE DATABASE [mydatabase] WITH RECOVERY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2009 at 2:55 am
thanks, thats something i didnt know. I knew you could get ESX3.5i (got a copy myself) but i didnt know they gave away ESX 3.5, presumably you dont get virtual...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2009 at 2:50 am
Homebrew01
BTW what edition/version of vmware are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2009 at 12:42 pm
SQL Noob (4/6/2009)
on the free version of ESX server
presumably you are refferring to VMWare Server 2, there is a vast difference between ESX server and Vmware Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2009 at 12:38 pm
Salma
you may want to include brackets around the database name too like so
backup database [Update_Master_Khasm] to disk = '\\10.1.5.250\Khasm\igmastback'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2009 at 3:42 am
webqatesting (4/5/2009)
HiUnfortunately we are not sure about the recovery model and all.
Ok, now i'm a little worried :unsure:
right click the database and check the options on the database properties dialog...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2009 at 3:36 am
Krishna Potlakayala (4/3/2009)
As Grant mentioned, what recovery model it is in?
Grant who??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2009 at 3:27 am
after the upgrade from sql2000 to sql2005 did you run the DBCC Updateusage and rebuild indexes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2009 at 3:54 pm
kiran.kamuganti (4/3/2009)
FYI: I tried with generate script from all tasks by selecting the object level permissions and it is of no use.
you havent tried very hard then have you!
either the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2009 at 5:23 am
webqatesting (4/3/2009)
I have an application with SQL Server 2005 as the database.
Recently i'm getting an error " transaction log of the [mydatabase] is full ".
I searched for this error and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2009 at 5:14 am
Viewing 15 posts - 8,266 through 8,280 (of 9,241 total)