Viewing 15 posts - 436 through 450 (of 535 total)
Steve Jones - Editor (2/23/2008)
February 29, 2008 at 9:49 am
best place to start is books online. there are some good high level overviews of how each replication type works and will help you make your decision on what...
February 28, 2008 at 2:29 pm
you need to use the alter database statement (look in BOL). you specify the new filename for the data and log files and then restart the sql service.
As SQL...
February 25, 2008 at 11:55 pm
Thanks all for your responses!! 3 very different solutions to the same problem 🙂 I think ill give the last solution a go monitoring from a remote box...
February 25, 2008 at 12:45 am
It still sounds like you dont have any privileges on the server except for grant login. When you go to security and look at the properties for your user/group...
February 24, 2008 at 12:43 pm
It seems your issue is to do with the permissions of the user your using to create the DB. As vista is different than XP,2000 in that the local...
February 24, 2008 at 2:31 am
Log shipping also requires full recovery mode, and im pretty sure mirroring does as well.
Point in time restore requires full recovery model.
Thats all i can think of right...
February 24, 2008 at 2:20 am
select c.accountid,c.offername,min(c.startdate),max(c.enddate)
from billingRecord c
where c.bundlename like '%pack%' and
c.accountid='9ABD'
group by c.accountid,c.offername
That should work, not checked it but i cant see why it wouldnt. You could also query the table twice...
February 22, 2008 at 11:27 am
basically its as simple as how much room you have. Log files do not stripe data like data files do, sql will fill the first log file, then move...
February 21, 2008 at 6:33 am
FYI - I just tried creating a db called my-db and it worked ok. Not sure why it fails for you.
February 19, 2008 at 10:28 am
does it work when you put square brackets around the name? The database name looks ok i think, the legnth is ok (i think the max is 128 chars)...
February 19, 2008 at 10:09 am
Hi there,
Yes it is purely tables i am replicating.
February 19, 2008 at 1:29 am
im pretty sure that it shows all databases you have access too. I guess if you dont want to see them, create a new user with access to your...
February 17, 2008 at 6:53 am
I had the same problem and it was cured via a restart of SQL Agent.
Wait until you reboot the server again, its hit and miss whether the problem reoccurs :angry:
February 14, 2008 at 10:11 am
Viewing 15 posts - 436 through 450 (of 535 total)