Viewing 15 posts - 8,881 through 8,895 (of 9,241 total)
Use something along the following lines
RESTORE DATABASE MYNEWDBNAME FROM DISK = 'D:\PATHTOFILE\BACKUPFILE.BAK'
WITH MOVE 'MDF LOGICAL FILENAME' TO 'F:\NEWPATH\NEWFILENAME.MDF',
MOVE 'LDF LOGICAL FILENAME' TO 'E:\NEWPATH\NEWFILENAME.LDF',
RECOVERY
Replace shouldnt be needed as the new physical...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 11:01 am
when setting up log shipping it can have 1 of 2 states, WITH STANDBY or WITH NO_RECOVERY
STANDBY is the first. The database is in a read only state and clients...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:52 am
you would probably need the latest MDAC update for the SQL driver
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:49 am
you could also run a repair of the .NET framework via add\remove programs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2008 at 10:41 am
might i suggest if you have access to a virtualisation technology have a go at clustering on a couple of test servers before implementing. Virtual server Enterprise 2005 will happily...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 7:57 am
generally consult your application vendor!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:59 am
sandhyarao49 (9/16/2008)
Hi,I want to move the logins from one server to another server.
Could anyone suggest on this in a simple way.
Thanks,
Sandhya
depends on the flavour of source and target sql server
the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:57 am
Hi
you can also do this by setting the database to offline, use the alter database modify file statement and then set back to online after.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 6:50 am
sunshine (9/15/2008)
the previous statement must be terminated with a semicolon.
this message is fairly descriptive!! The USE statement and exec must be separated by a semi colon like so
SELECT @execmd =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2008 at 5:22 am
also, SQL2005 is able to address as much RAM as the NOS will allow 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 1:38 pm
Ninja's_RGR'us (9/15/2008)
Like I tested it and in this case exists is faster than in?
thats what i'm asking
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:33 am
Dana Bibeault (9/15/2008)
Can I install Windows Enterprise and run SQL 2005 Standard Edition?
that will be just fine, you'll need Enterprise edition of Windows server to address the extra RAM as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:30 am
Hi
i'm contracting at present, checkout Jobbserve and you'll see plenty of SQL opportunities both home and abroad
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2008 at 10:24 am
Steve
check with Esri but i'm sure changing the logical filenames will make no difference. The SDE database will be referenced by the database name only not by logical filename.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2008 at 3:53 pm
Grant Hoerz (9/11/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 11, 2008 at 3:42 pm
Viewing 15 posts - 8,881 through 8,895 (of 9,241 total)