I have a site hosted with another hosting company. My database is in MSSQL. I want to take a weekly backup of my database from the hosting server on to my backup device. How can I do this? Can I do it by using EM? Please advise.In article <4651AD67-5E8D-4719-BB13-AFE7305D777B@.microsoft.com>,
carrol_z@.yahoo.com said...
> I have a site hosted with another hosting company. My database is in
> MSSQL. I want to take a weekly backup of my database from the hosting
> server on to my backup device. How can I do this? Can I do it by using EM?
Only if your backup device is attached to the hosting company's server.
Otherwise you're going to have to back it up there and transfer it. Any
decent hosting company will have a backup and archival option.
Showing posts with label company. Show all posts
Showing posts with label company. Show all posts
Monday, March 19, 2012
Thursday, March 8, 2012
Database adapter?
So what exactly is a database adapter? There is a company that wants to
provide reporting services to our customers using a proprietary technology,
but all they will tell us is they use an adapter and a listener through
ODBC. Seems to me that an adapter is just a fancy way of saying a wrapper
over ODBC and the listener must be installing some type of triggers or
something. I am psychotically opposed to any third party application
installing any objects into our databases. "Adapter" is a pretty darned
generic term and I'm not really comfortable with their explanation. I need
to be able to ask better questions.
Bob Castleman
DBA PoseurIt is possible that they have an ADO.NET DataAdapter. If so, it lives in
their application and not in your database. And yes, it's basically a
wrapper that encapsulates database-specific connection properties and
methods. But that's just a wild guess as to what *they* mean by "data
adapter".
-HTH
"Bob Castleman" <nomail@.here> wrote in message
news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
> So what exactly is a database adapter? There is a company that wants to
> provide reporting services to our customers using a proprietary
> technology, but all they will tell us is they use an adapter and a
> listener through ODBC. Seems to me that an adapter is just a fancy way of
> saying a wrapper over ODBC and the listener must be installing some type
> of triggers or something. I am psychotically opposed to any third party
> application installing any objects into our databases. "Adapter" is a
> pretty darned generic term and I'm not really comfortable with their
> explanation. I need to be able to ask better questions.
> Bob Castleman
> DBA Poseur
>|||The adapter part seems obvious to me, but what is not at all clear is how
this can *sense* updates to the database without installing triggers.
Hmmmm.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
> It is possible that they have an ADO.NET DataAdapter. If so, it lives in
> their application and not in your database. And yes, it's basically a
> wrapper that encapsulates database-specific connection properties and
> methods. But that's just a wild guess as to what *they* mean by "data
> adapter".
> -HTH
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
>|||<< not at all clear is how this can *sense* updates to the database >>
Maybe they use classes in the System.Voodoo namespace in conjunction with
their ADO.NET DataAdapter.
without knowing more, and grasping for possibilities, maybe they
periodically query the db and compare against values in the application's
memory or perhaps compare to values persisted to a local disk where the app
is running... but that gets ugly quickly if they're doing it that way.
Can you tell us more about what they plan to actually install, and where it
gets installed? This "listening" thing is puzzling. Are they installling a
Windows Service that will broadcast on some port that gets listened to? Are
they setting up some custom TCP Server?
-JT
"Bob Castleman" <nomail@.here> wrote in message
news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
> The adapter part seems obvious to me, but what is not at all clear is how
> this can *sense* updates to the database without installing triggers.
> Hmmmm.
>
> Bob
> "Jeffrey Todd" <Me@.Somewhere.net> wrote in message
> news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
>|||Well it turns out that after beating them upside the head they finally
admitting to using triggers. I have no clue why they were so freaking
secretive.
This brings up my next question. Would any DBA worth anything ever allow a
third party application to install triggers? In my mind, my database is
sacred and NOBODY outside of my organization can change it. Technically, a
trigger isn't a schema change, but I have real problems with somebody else
sticking objects in my databases.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OJbRvDTbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> << not at all clear is how this can *sense* updates to the database >>
> Maybe they use classes in the System.Voodoo namespace in conjunction with
> their ADO.NET DataAdapter.
> without knowing more, and grasping for possibilities, maybe they
> periodically query the db and compare against values in the application's
> memory or perhaps compare to values persisted to a local disk where the
> app is running... but that gets ugly quickly if they're doing it that way.
> Can you tell us more about what they plan to actually install, and where
> it gets installed? This "listening" thing is puzzling. Are they
> installling a Windows Service that will broadcast on some port that gets
> listened to? Are they setting up some custom TCP Server?
> -JT
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
>|||"Bob Castleman":
> Well it turns out that after beating them upside the head they finally
> admitting to using triggers. I have no clue why they were so freaking
> secretive.
> This brings up my next question. Would any DBA worth anything ever allow a
> third party application to install triggers? In my mind, my database is
> sacred and NOBODY outside of my organization can change it. Technically, a
> trigger isn't a schema change, but I have real problems with somebody else
> sticking objects in my databases.
> Bob
Personally, I wouldn't allow it: I don't like allowing in-house personnel to
add triggers :)
One thing: is this solution for auditing all database activity? If that's
what you're looking for, you can try Lumigent. I like their Log Explorer
product, but they also have a full-blown activity audit product called (I
think) Entegra: obviously it's a lot more expensive.
Their products are based on proprietary technology that examines the SQL
Server log files, so no triggers or any other schema change. (Log Explorer
does need it's own database, so I assume Integra does as well).
Craig|||It's just a reporting application. What bugs me is that we have an XML based
API but the refuse to use it.
The log explorers are something I've looked at briefly for auditing.
Especially in light of SOX, they might be useful. It could be a convenient
way to maintain audit trails.
Bob
"Craig Kelly" <cnkelly@.spamnomore.worldnet.att.net> wrote in message
news:z14qe.302594$cg1.243213@.bgtnsc04-news.ops.worldnet.att.net...
> "Bob Castleman":
>
> Personally, I wouldn't allow it: I don't like allowing in-house personnel
> to add triggers :)
> One thing: is this solution for auditing all database activity? If that's
> what you're looking for, you can try Lumigent. I like their Log Explorer
> product, but they also have a full-blown activity audit product called (I
> think) Entegra: obviously it's a lot more expensive.
> Their products are based on proprietary technology that examines the SQL
> Server log files, so no triggers or any other schema change. (Log
> Explorer does need it's own database, so I assume Integra does as well).
> Craig
>
provide reporting services to our customers using a proprietary technology,
but all they will tell us is they use an adapter and a listener through
ODBC. Seems to me that an adapter is just a fancy way of saying a wrapper
over ODBC and the listener must be installing some type of triggers or
something. I am psychotically opposed to any third party application
installing any objects into our databases. "Adapter" is a pretty darned
generic term and I'm not really comfortable with their explanation. I need
to be able to ask better questions.
Bob Castleman
DBA PoseurIt is possible that they have an ADO.NET DataAdapter. If so, it lives in
their application and not in your database. And yes, it's basically a
wrapper that encapsulates database-specific connection properties and
methods. But that's just a wild guess as to what *they* mean by "data
adapter".
-HTH
"Bob Castleman" <nomail@.here> wrote in message
news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
> So what exactly is a database adapter? There is a company that wants to
> provide reporting services to our customers using a proprietary
> technology, but all they will tell us is they use an adapter and a
> listener through ODBC. Seems to me that an adapter is just a fancy way of
> saying a wrapper over ODBC and the listener must be installing some type
> of triggers or something. I am psychotically opposed to any third party
> application installing any objects into our databases. "Adapter" is a
> pretty darned generic term and I'm not really comfortable with their
> explanation. I need to be able to ask better questions.
> Bob Castleman
> DBA Poseur
>|||The adapter part seems obvious to me, but what is not at all clear is how
this can *sense* updates to the database without installing triggers.
Hmmmm.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
> It is possible that they have an ADO.NET DataAdapter. If so, it lives in
> their application and not in your database. And yes, it's basically a
> wrapper that encapsulates database-specific connection properties and
> methods. But that's just a wild guess as to what *they* mean by "data
> adapter".
> -HTH
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:eKI2vPRbFHA.2420@.TK2MSFTNGP15.phx.gbl...
>|||<< not at all clear is how this can *sense* updates to the database >>
Maybe they use classes in the System.Voodoo namespace in conjunction with
their ADO.NET DataAdapter.
without knowing more, and grasping for possibilities, maybe they
periodically query the db and compare against values in the application's
memory or perhaps compare to values persisted to a local disk where the app
is running... but that gets ugly quickly if they're doing it that way.
Can you tell us more about what they plan to actually install, and where it
gets installed? This "listening" thing is puzzling. Are they installling a
Windows Service that will broadcast on some port that gets listened to? Are
they setting up some custom TCP Server?
-JT
"Bob Castleman" <nomail@.here> wrote in message
news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
> The adapter part seems obvious to me, but what is not at all clear is how
> this can *sense* updates to the database without installing triggers.
> Hmmmm.
>
> Bob
> "Jeffrey Todd" <Me@.Somewhere.net> wrote in message
> news:OTpcBmRbFHA.2212@.TK2MSFTNGP14.phx.gbl...
>|||Well it turns out that after beating them upside the head they finally
admitting to using triggers. I have no clue why they were so freaking
secretive.
This brings up my next question. Would any DBA worth anything ever allow a
third party application to install triggers? In my mind, my database is
sacred and NOBODY outside of my organization can change it. Technically, a
trigger isn't a schema change, but I have real problems with somebody else
sticking objects in my databases.
Bob
"Jeffrey Todd" <Me@.Somewhere.net> wrote in message
news:OJbRvDTbFHA.3240@.TK2MSFTNGP12.phx.gbl...
> << not at all clear is how this can *sense* updates to the database >>
> Maybe they use classes in the System.Voodoo namespace in conjunction with
> their ADO.NET DataAdapter.
> without knowing more, and grasping for possibilities, maybe they
> periodically query the db and compare against values in the application's
> memory or perhaps compare to values persisted to a local disk where the
> app is running... but that gets ugly quickly if they're doing it that way.
> Can you tell us more about what they plan to actually install, and where
> it gets installed? This "listening" thing is puzzling. Are they
> installling a Windows Service that will broadcast on some port that gets
> listened to? Are they setting up some custom TCP Server?
> -JT
>
> "Bob Castleman" <nomail@.here> wrote in message
> news:uZ5ml4RbFHA.720@.TK2MSFTNGP15.phx.gbl...
>|||"Bob Castleman":
> Well it turns out that after beating them upside the head they finally
> admitting to using triggers. I have no clue why they were so freaking
> secretive.
> This brings up my next question. Would any DBA worth anything ever allow a
> third party application to install triggers? In my mind, my database is
> sacred and NOBODY outside of my organization can change it. Technically, a
> trigger isn't a schema change, but I have real problems with somebody else
> sticking objects in my databases.
> Bob
Personally, I wouldn't allow it: I don't like allowing in-house personnel to
add triggers :)
One thing: is this solution for auditing all database activity? If that's
what you're looking for, you can try Lumigent. I like their Log Explorer
product, but they also have a full-blown activity audit product called (I
think) Entegra: obviously it's a lot more expensive.
Their products are based on proprietary technology that examines the SQL
Server log files, so no triggers or any other schema change. (Log Explorer
does need it's own database, so I assume Integra does as well).
Craig|||It's just a reporting application. What bugs me is that we have an XML based
API but the refuse to use it.
The log explorers are something I've looked at briefly for auditing.
Especially in light of SOX, they might be useful. It could be a convenient
way to maintain audit trails.
Bob
"Craig Kelly" <cnkelly@.spamnomore.worldnet.att.net> wrote in message
news:z14qe.302594$cg1.243213@.bgtnsc04-news.ops.worldnet.att.net...
> "Bob Castleman":
>
> Personally, I wouldn't allow it: I don't like allowing in-house personnel
> to add triggers :)
> One thing: is this solution for auditing all database activity? If that's
> what you're looking for, you can try Lumigent. I like their Log Explorer
> product, but they also have a full-blown activity audit product called (I
> think) Entegra: obviously it's a lot more expensive.
> Their products are based on proprietary technology that examines the SQL
> Server log files, so no triggers or any other schema change. (Log
> Explorer does need it's own database, so I assume Integra does as well).
> Craig
>
Database Access (client) to Specific machines in LAN network.
Hi ,
We have a LAN set up in our company . I want that some specific local
machine's IP addresses to have access the live database server.
Want to restict machine's IP address from connecting to the live database
. How can I go for this ? I donot have that much idea about firewall and
router stuff . pls send me the link also which will help me in doing this.
I do have complex password for SA and have created a different login /role
and users for specific rights .But still want to do the above thing to make
the database more secured.
Pls help me in this.
Regards,
Swatiusing ipsec u can achive this. It is a filter. u can allow and disallow i.ps
.
"swati" wrote:
> Hi ,
> We have a LAN set up in our company . I want that some specific local
> machine's IP addresses to have access the live database server.
> Want to restict machine's IP address from connecting to the live databas
e
> .. How can I go for this ? I donot have that much idea about firewall and
> router stuff . pls send me the link also which will help me in doing this.
> I do have complex password for SA and have created a different login /role
> and users for specific rights .But still want to do the above thing to mak
e
> the database more secured.
> Pls help me in this.
> Regards,
> Swati
>
>
>
>|||Hi Suresh ,
Canyou pls throw some light on how to use the ipsec ? I am totally new in
this area . Waiting for your reply
Thanks & Regards,
Swati
"suresh" <suresh@.discussions.microsoft.com> wrote in message
news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> using ipsec u can achive this. It is a filter. u can allow and disallow
i.ps.[vbcol=seagreen]
>
> "swati" wrote:
>
database[vbcol=seagreen]
and[vbcol=seagreen]
this.[vbcol=seagreen]
/role[vbcol=seagreen]
make[vbcol=seagreen]|||http://www.microsoft.com/technet/it...ty/ipsecld.mspx
Using IPSec to Lock Down a Server
is a good start
Cheers
Ken
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:O3U6tii7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> Hi Suresh ,
> Canyou pls throw some light on how to use the ipsec ? I am totally new in
> this area . Waiting for your reply
> Thanks & Regards,
> Swati
>
> "suresh" <suresh@.discussions.microsoft.com> wrote in message
> news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> i.ps.
> database
> and
> this.
> /role
> make
>
We have a LAN set up in our company . I want that some specific local
machine's IP addresses to have access the live database server.
Want to restict machine's IP address from connecting to the live database
. How can I go for this ? I donot have that much idea about firewall and
router stuff . pls send me the link also which will help me in doing this.
I do have complex password for SA and have created a different login /role
and users for specific rights .But still want to do the above thing to make
the database more secured.
Pls help me in this.
Regards,
Swatiusing ipsec u can achive this. It is a filter. u can allow and disallow i.ps
.
"swati" wrote:
> Hi ,
> We have a LAN set up in our company . I want that some specific local
> machine's IP addresses to have access the live database server.
> Want to restict machine's IP address from connecting to the live databas
e
> .. How can I go for this ? I donot have that much idea about firewall and
> router stuff . pls send me the link also which will help me in doing this.
> I do have complex password for SA and have created a different login /role
> and users for specific rights .But still want to do the above thing to mak
e
> the database more secured.
> Pls help me in this.
> Regards,
> Swati
>
>
>
>|||Hi Suresh ,
Canyou pls throw some light on how to use the ipsec ? I am totally new in
this area . Waiting for your reply
Thanks & Regards,
Swati
"suresh" <suresh@.discussions.microsoft.com> wrote in message
news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> using ipsec u can achive this. It is a filter. u can allow and disallow
i.ps.[vbcol=seagreen]
>
> "swati" wrote:
>
database[vbcol=seagreen]
and[vbcol=seagreen]
this.[vbcol=seagreen]
/role[vbcol=seagreen]
make[vbcol=seagreen]|||http://www.microsoft.com/technet/it...ty/ipsecld.mspx
Using IPSec to Lock Down a Server
is a good start
Cheers
Ken
"swati" <swati.zingade@.ugamsolutions.com> wrote in message
news:O3U6tii7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> Hi Suresh ,
> Canyou pls throw some light on how to use the ipsec ? I am totally new in
> this area . Waiting for your reply
> Thanks & Regards,
> Swati
>
> "suresh" <suresh@.discussions.microsoft.com> wrote in message
> news:35ED9BA4-EC43-4350-9CBE-81141FC72466@.microsoft.com...
> i.ps.
> database
> and
> this.
> /role
> make
>
Saturday, February 25, 2012
Data warehousing design
Hi
We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?
Thanks,
TeaaZAIf you are building a true data warehouse, then get the books written by Bill Inmon. If you are building a small data mart, then you might consider Kimball's books.
We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?
Thanks,
TeaaZAIf you are building a true data warehouse, then get the books written by Bill Inmon. If you are building a small data mart, then you might consider Kimball's books.
Subscribe to:
Posts (Atom)