Viewing 15 posts - 8,281 through 8,295 (of 9,253 total)
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
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...
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
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...
April 7, 2009 at 2:50 am
Homebrew01
BTW what edition/version of vmware are you using?
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
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'
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...
April 6, 2009 at 3:36 am
Krishna Potlakayala (4/3/2009)
As Grant mentioned, what recovery model it is in?
Grant who??
April 6, 2009 at 3:27 am
after the upgrade from sql2000 to sql2005 did you run the DBCC Updateusage and rebuild indexes?
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...
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...
April 3, 2009 at 5:14 am
once you start the restore process if you then kill it you have to wait for it to roll back, this could take some time, hence why it still shows...
April 2, 2009 at 4:12 pm
in future, for sql2000 queries please post in the correct forum area 😉
April 2, 2009 at 4:10 pm
Viewing 15 posts - 8,281 through 8,295 (of 9,253 total)