Viewing 15 posts - 8,266 through 8,280 (of 9,244 total)
simply
backup and restore
or
detach and attach
the SQL 7 database to the SQL 2005 server and all the identities should be fine
dont forget to update usages and rebuild indexes afterwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 1:41 pm
what file system is the USB drive formatted with?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 1:22 pm
Achtang (4/8/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2009 at 8:46 am
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
Viewing 15 posts - 8,266 through 8,280 (of 9,244 total)