Database Unit Testing: enterprise

Showing posts with label enterprise. Show all posts

Tuesday, March 27, 2012

Database Snapshots vs Snaphot replication

In the enterprise version of SQL there is the facility to do snapshot
replication which I have not tried.
How does this differ from snapshot replication?
What this does is capture a point in time image of a database which you can
connect to as a different database.
Database snapshots are local to the database and uses up considerable disk
space. Snapshot replication can replicate locally and/or remote. It can
replicate to multiple subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PromisedOyster" <PromisedOyster@.hotmail.com> wrote in message
news:1170891510.578187.22220@.v33g2000cwv.googlegro ups.com...
> In the enterprise version of SQL there is the facility to do snapshot
> replication which I have not tried.
> How does this differ from snapshot replication?
>
|||Thanks Hilary
My client is considering using mirroring for fault tolerance under SQL
Server 2005 but they also require a version of the database that is
reasonably up to date for reporting purposes. They dont have the
Enterprise version of SQL, so I was wondering if mirroring and then
doing snapshot replication (from the mirror) would be a viable
solution. I suspect not as the database would be unavailable for too
long. In addition, I am not even sure if this is an available option.
NB: They are unable to use transactional or merge replication due to
the tables not having primary keys.
I know that snapshot replication can be extremely slow but I am not
sure how much faster database snapshots are? In addition, when you do
them, can you simply overwrite the previous one as you dont want the
clients to have to access a different database?
Bottom line, is it a viable solution to make multiple database
snapshots during the course of a production day (from the mirror)?
I dont want to propose going to Enterprise version if it isnt going to
work.
On Feb 8, 12:29 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> What this does is capture a point in time image of a database which you can
> connect to as a different database.
> Database snapshots are local to the database and uses up considerable disk
> space. Snapshot replication can replicate locally and/or remote. It can
> replicate to multiple subscribers.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "PromisedOyster" <PromisedOys...@.hotmail.com> wrote in message
> news:1170891510.578187.22220@.v33g2000cwv.googlegro ups.com...
>
>
> - Show quoted text -
|||One problem, you can't do snapshot replication off a mirror.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"PromisedOyster" <PromisedOyster@.hotmail.com> wrote in message
news:1170908921.373111.263690@.v33g2000cwv.googlegr oups.com...
> Thanks Hilary
> My client is considering using mirroring for fault tolerance under SQL
> Server 2005 but they also require a version of the database that is
> reasonably up to date for reporting purposes. They dont have the
> Enterprise version of SQL, so I was wondering if mirroring and then
> doing snapshot replication (from the mirror) would be a viable
> solution. I suspect not as the database would be unavailable for too
> long. In addition, I am not even sure if this is an available option.
> NB: They are unable to use transactional or merge replication due to
> the tables not having primary keys.
> I know that snapshot replication can be extremely slow but I am not
> sure how much faster database snapshots are? In addition, when you do
> them, can you simply overwrite the previous one as you dont want the
> clients to have to access a different database?
> Bottom line, is it a viable solution to make multiple database
> snapshots during the course of a production day (from the mirror)?
> I dont want to propose going to Enterprise version if it isnt going to
> work.
> On Feb 8, 12:29 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>
|||Thanks, well I guess I can rule out snapshot replication.
However, what about database snapshots. How feasible is it to take
them once every half hour (say) and overwrite the existing one and
then use that as the reporting database server?
On Feb 8, 8:18 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> One problem, you can't do snapshot replication off a mirror.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "PromisedOyster" <PromisedOys...@.hotmail.com> wrote in message
> news:1170908921.373111.263690@.v33g2000cwv.googlegr oups.com...
>
>
>
>
>
>
>
>
>
> - Show quoted text -

Thursday, March 22, 2012

Database Size (Free,Used)

In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,
See sp_spaceused in SQL Server Books Online. In master databse, you could
run the following to see what tables this procedure accesses:
sp_helptext sp_spaceused
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:805D5942-D569-4083-99B4-E537F845D880@.microsoft.com...
In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,
|||Hi Joe,
Sysindexes system table in each database stores all the space information. You could also use the system stored procedure
"sp_spaceused " to get the space usage. For transaction log usage use DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
____________________________________
Joe K. Wrote:
In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,
Sent via SreeSharp NewsReader http://www.SreeSharp.com
sql

Database Size (Free,Used)

In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,See sp_spaceused in SQL Server Books Online. In master databse, you could
run the following to see what tables this procedure accesses:
sp_helptext sp_spaceused
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:805D5942-D569-4083-99B4-E537F845D880@.microsoft.com...
In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,|||Hi Joe,
Sysindexes system table in each database stores all the space information. Y
ou could also use the system stored procedure
"sp_spaceused " to get the space usage. For transaction log usage use DBCC S
QLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
____________________________________
Joe K. Wrote:
In SQL Server Enterprise Manager taskpad will display database size free and
used space.
What tables within SQL Server is this information stored?
Is there another way to obtain database size free and used space?
Thanks,
Sent via SreeSharp NewsReader http://www.SreeSharp.com

Database Size (Free,Used)

Database size > 250 Gig

We all know and hear that Sql 2000 is an enterprise
database now. However, stories ( rumors if you may ) still
make the rounds that people with any database in excess of
50G gives lots of problems. I've been asked to recommend a
database server in my organization for a database that
will start at 300G and is expected to reach 500G. I would
like for it to be MS Sql Server. However, I would really
like to know how many people on this board actually use
database's that large and whether Sql Server is really the
platform of choice for those VLDB's. We all love Sql
Server but Lets be honest here.I have working databases with over 1TB of data. I also have databases with
300GB throughput per month. A properly designed and maintained system can
handle that kind of data load with SQL Server. It won't run 'out of the
box' with little or no planning and maintenance, but it can handle it with a
competent DBA running the show.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Jack A" <jacka8@.excite.com> wrote in message
news:019101c3c323$88ba2c80$a101280a@.phx.gbl...
> We all know and hear that Sql 2000 is an enterprise
> database now. However, stories ( rumors if you may ) still
> make the rounds that people with any database in excess of
> 50G gives lots of problems. I've been asked to recommend a
> database server in my organization for a database that
> will start at 300G and is expected to reach 500G. I would
> like for it to be MS Sql Server. However, I would really
> like to know how many people on this board actually use
> database's that large and whether Sql Server is really the
> platform of choice for those VLDB's. We all love Sql
> Server but Lets be honest here.|||> We all know and hear that Sql 2000 is an enterprise
> database now. However, stories ( rumors if you may ) still
> make the rounds that people with any database in excess of
> 50G gives lots of problems.
I think it may be the case that "large" databases require a little more
knowledge to manage in general, rather than specifically with SQL Server.
We are running SQL Server 2000 on both Windows Server 2000 and Windows
Server 2003, and we have multiple databases in the 600 GB -> 1.5 TB range.
SQL Server itself has not given any extra hassles that we wouldn't expect to
see with any RDBMS (e.g. issues not relating specifically to database
technology, such as data transfer keeping up over a dodgy network
connection).
> We all love Sql Server but Lets be honest here.
SQL Server is more than capable of handling VLDB. Space management can be
an issue, as well as network connectivity to a SAN, and the length of time
required to perform reliable backups. But this would be no different if I
were using Oracle, DB2, etc. Do you have a "perfect" RDBMS in mind, that
isn't vulnerable to any of the issues associated with large data stores?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||> were using Oracle, DB2, etc. Do you have a "perfect" RDBMS in mind, that
> isn't vulnerable to any of the issues associated with large data stores?
Heh, and as Geoff pointed out, that wouldn't require a DBA on staff to plan
and manage...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||In general, SQL Server doesn't have any issue with
managing >200GB databases.
In addition to others' comments, there are some specific
DBMS issues you may want to know. In particular, if your
database is used very heavily 24x7 with very large tables,
you may run into the nasty problem of not being able to re-
org your indexes online. You could try DBCC INDEXDEFRAG
for some relief. It may or may not be an effective
solution for a particular situation.
Again, this may not be a concern for you.
Linchi
>--Original Message--
>We all know and hear that Sql 2000 is an enterprise
>database now. However, stories ( rumors if you may )
still
>make the rounds that people with any database in excess
of
>50G gives lots of problems. I've been asked to recommend
a
>database server in my organization for a database that
>will start at 300G and is expected to reach 500G. I would
>like for it to be MS Sql Server. However, I would really
>like to know how many people on this board actually use
>database's that large and whether Sql Server is really
the
>platform of choice for those VLDB's. We all love Sql
>Server but Lets be honest here.
>.
>|||Thanks a ton. Will keep you guys posted of how things go.
>--Original Message--
>> were using Oracle, DB2, etc. Do you have a "perfect"
RDBMS in mind, that
>> isn't vulnerable to any of the issues associated with
large data stores?
>Heh, and as Geoff pointed out, that wouldn't require a
DBA on staff to plan
>and manage...
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>.
>

Database Size

quote:

> I am attempting to create a new database with a size of 7gig. I have =

16 gig available but Enterprise Manager errors with not enough disk =
space with any attempt greater than 4gig. any suggestions are very much =
welcomed|||Hi,
From Query analyzer , execute the below Extended procedure and identify the
hard disk availability,
xp_fixeddrives
Thanks
Hari
MCDBA
"needing help" <anonymous@.discussions.microsoft.com> wrote in message
news:737D769F-71B3-40F0-A2FD-DB8C609273F3@.microsoft.com...

quote:

> I am attempting to create a new database with a size of 7gig. I have 16

gig available but Enterprise Manager errors with not enough disk space with
any attempt greater than 4gig. any suggestions are very much welcomed|||I execute the produre and it confirms the drive has 16515MB free. The drive
is formatted to FAT32 much to my suprise

Database Size

I am attempting to create a new database with a size of 7gig. I have 16 gig available but Enterprise Manager errors with not enough disk space with any attempt greater than 4gig. any suggestions are very much welcomedAll I can think of is that the file system is FAT rather thjan NTFS.
It is always recommended to use NTFS for SQL Server
Mike John
"needing help" <anonymous@.discussions.microsoft.com> wrote in message =news:737D769F-71B3-40F0-A2FD-DB8C609273F3@.microsoft.com...
> I am attempting to create a new database with a size of 7gig. I have =16 gig available but Enterprise Manager errors with not enough disk =space with any attempt greater than 4gig. any suggestions are very much =welcomed|||Hi,
From Query analyzer , execute the below Extended procedure and identify the
hard disk availability,
xp_fixeddrives
Thanks
Hari
MCDBA
"needing help" <anonymous@.discussions.microsoft.com> wrote in message
news:737D769F-71B3-40F0-A2FD-DB8C609273F3@.microsoft.com...
> I am attempting to create a new database with a size of 7gig. I have 16
gig available but Enterprise Manager errors with not enough disk space with
any attempt greater than 4gig. any suggestions are very much welcomed|||I execute the produre and it confirms the drive has 16515MB free. The drive is formatted to FAT32 much to my suprisesql

Wednesday, March 21, 2012

Database Service Won't Start

We have multiple instances at Windows 2000 Advanced Server. One default
database is Enterprise Edition and another two instances are Developer
Editions. They have been running fine until recently.
We can start ANY ONE instance from the EM, only ONE. None of any other
services can be started anymore. Not even SQL Agent. We have to start
rest of other database services and sql agent from command line.
When we try to connect the SQL Server or Agent from the EM, we got
"Error 1053 - (The service did not respond to the start or control
request in a timely fashion) occured while performing this service
operation on the MSSQL service."
Thought maybe some corrpution to currnet databases, DLL etc. Installed
another new instance on the server, got the same error message.
Verified Microsoft KB article 322140, does not seem apply to us.
Any opinion is appreciated.Hi,
What you could do is first backup all the databases currently running on your
server.
1) Please never install Enterprise Edition and Developer Edition on the Same
Drive.
2) Install both of them on separate Drives.
3) Setup the Client and Server Tools for only the Enterprise Edition.
4) And when installing the Developer Editions, install only the Server and
not the client tools.
I faced a similar problem when I installed SQL Server 2000 and SQL server
2005 express on the same drive.
So when I installed it on separate drives, no problems faced yet :)
Hope this helps :)
--
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via SQLMonster.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on your
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Same
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet :)
> Hope this helps :)
> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1

Database Service Won't Start

Hope this helps

Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via droptable.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on y
our
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Sa
me
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet

> Hope this helps

> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200609/1

Database Service Won't Start

Hope this helps

Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1
|||Thanks for your response.
But it works fine before, until 2 weeks ago. Now I can start them from
command line.
Thanks.
DB2DOTNETCZAR via droptable.com wrote:
> Hi,
> What you could do is first backup all the databases currently running on your
> server.
> 1) Please never install Enterprise Edition and Developer Edition on the Same
> Drive.
> 2) Install both of them on separate Drives.
> 3) Setup the Client and Server Tools for only the Enterprise Edition.
> 4) And when installing the Developer Editions, install only the Server and
> not the client tools.
> I faced a similar problem when I installed SQL Server 2000 and SQL server
> 2005 express on the same drive.
> So when I installed it on separate drives, no problems faced yet

> Hope this helps

> --
> Best Regards
> Anil Mahadev
> http://anilm001.myfreewebs.net/index2.php
> http://www.db2india.org
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200609/1

Database server layout

Hi All,
Being small, we have only one database server that serves our need (SQL
2000 Enterprise Edition). We never had any replication or mirroring.
Now we will be installing SQL 2005.
I was asked to look into the best way of creating a good database
server so that we will not have any downtime.
At the present if we need to stop/restart or something goes wrong with
the server, then we loose many working hours sometimes even a few days.
Could you please point me the right direction (articles, web link) so
that I can see an example of good database server layout?
I do appreciate your help.
Thanks a million in advance.
Best regards,
MamunHi Mamun
I would suggest the best and most cost effective solution with the lease
amount of administrative effort would have to be mirroring. THe SQL Native
Client monitors the server status and fails over automatically for you and
your applications can continue working without have to re-establish
connection again of having to wait for failovers to complete. We tested
mirroring extensively and achieved failover in 5 sec, MS claim u can be up
and running on the mirror instance in 3 sec.
have a look at it, i'm sure it would fulfill all your needs
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
--
http://www.sqlserver.co.za
"mamun_ah@.hotmail.com" wrote:
> Hi All,
> Being small, we have only one database server that serves our need (SQL
> 2000 Enterprise Edition). We never had any replication or mirroring.
> Now we will be installing SQL 2005.
> I was asked to look into the best way of creating a good database
> server so that we will not have any downtime.
> At the present if we need to stop/restart or something goes wrong with
> the server, then we loose many working hours sometimes even a few days.
>
> Could you please point me the right direction (articles, web link) so
> that I can see an example of good database server layout?
> I do appreciate your help.
> Thanks a million in advance.
> Best regards,
> Mamun
>

Database server layout

Hi All,
Being small, we have only one database server that serves our need (SQL
2000 Enterprise Edition). We never had any replication or mirroring.
Now we will be installing SQL 2005.
I was asked to look into the best way of creating a good database
server so that we will not have any downtime.
At the present if we need to stop/restart or something goes wrong with
the server, then we loose many working hours sometimes even a few days.
Could you please point me the right direction (articles, web link) so
that I can see an example of good database server layout?
I do appreciate your help.
Thanks a million in advance.
Best regards,
MamunHi Mamun
I would suggest the best and most cost effective solution with the lease
amount of administrative effort would have to be mirroring. THe SQL Native
Client monitors the server status and fails over automatically for you and
your applications can continue working without have to re-establish
connection again of having to wait for failovers to complete. We tested
mirroring extensively and achieved failover in 5 sec, MS claim u can be up
and running on the mirror instance in 3 sec.
have a look at it, i'm sure it would fulfill all your needs
http://www.microsoft.com/technet/pr...5/dbmirror.mspx
http://www.sqlserver.co.za
"mamun_ah@.hotmail.com" wrote:

> Hi All,
> Being small, we have only one database server that serves our need (SQL
> 2000 Enterprise Edition). We never had any replication or mirroring.
> Now we will be installing SQL 2005.
> I was asked to look into the best way of creating a good database
> server so that we will not have any downtime.
> At the present if we need to stop/restart or something goes wrong with
> the server, then we loose many working hours sometimes even a few days.
>
> Could you please point me the right direction (articles, web link) so
> that I can see an example of good database server layout?
> I do appreciate your help.
> Thanks a million in advance.
> Best regards,
> Mamun
>

Database server layout

Hi All,
Being small, we have only one database server that serves our need (SQL
2000 Enterprise Edition). We never had any replication or mirroring.
Now we will be installing SQL 2005.
I was asked to look into the best way of creating a good database
server so that we will not have any downtime.
At the present if we need to stop/restart or something goes wrong with
the server, then we loose many working hours sometimes even a few days.
Could you please point me the right direction (articles, web link) so
that I can see an example of good database server layout?
I do appreciate your help.
Thanks a million in advance.
Best regards,
Mamun
Hi Mamun
I would suggest the best and most cost effective solution with the lease
amount of administrative effort would have to be mirroring. THe SQL Native
Client monitors the server status and fails over automatically for you and
your applications can continue working without have to re-establish
connection again of having to wait for failovers to complete. We tested
mirroring extensively and achieved failover in 5 sec, MS claim u can be up
and running on the mirror instance in 3 sec.
have a look at it, i'm sure it would fulfill all your needs
http://www.microsoft.com/technet/pro.../dbmirror.mspx
http://www.sqlserver.co.za
"mamun_ah@.hotmail.com" wrote:

> Hi All,
> Being small, we have only one database server that serves our need (SQL
> 2000 Enterprise Edition). We never had any replication or mirroring.
> Now we will be installing SQL 2005.
> I was asked to look into the best way of creating a good database
> server so that we will not have any downtime.
> At the present if we need to stop/restart or something goes wrong with
> the server, then we loose many working hours sometimes even a few days.
>
> Could you please point me the right direction (articles, web link) so
> that I can see an example of good database server layout?
> I do appreciate your help.
> Thanks a million in advance.
> Best regards,
> Mamun
>
sql

Monday, March 19, 2012

Database Schema copy

I want to a DB, and create an empty DB with the same schema. This was
preety easy with Enterprise Manager, how can I do it with the new suite?
Using Management Studio, right click on the database name and select "Script
Database as".
Mark
"Dave H" <DaveH@.noemail.nospam> wrote in message
news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>I want to a DB, and create an empty DB with the same schema. This was
> preety easy with Enterprise Manager, how can I do it with the new suite?
>
|||I want the whole schema, that only does the DBCreate?
Dave
"mark sullivan" wrote:

> Using Management Studio, right click on the database name and select "Script
> Database as".
> Mark
>
> "Dave H" <DaveH@.noemail.nospam> wrote in message
> news:BZmdnbmZgJx5Y-DeRVn-tQ@.comcast.com...
>
>
|||Use the Generate Scripts Wizard: Right-click the database, point to Tasks,
and then click Generate Scripts.
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Dave H" <DaveH@.discussions.microsoft.com> wrote in message
news:BBC90ED6-8824-4731-B29A-2B1F3A83B680@.microsoft.com...[vbcol=seagreen]
>I want the whole schema, that only does the DBCreate?
> --
> Dave
>
> "mark sullivan" wrote:

Sunday, March 11, 2012

Database Runtime

I am Using Sql Server 2005 enterprise edition to develop an accounting system.
now i want to distribute this software to other cleints.
I have created a setup which includes all the components required for the run time of the software but i dont know how to include the sql server database in it.
as i know that i have created access based software i used to include the database file in the setup and it would work but in the case of sql server i dont know how to do it .
is there any runtime of sql server which needs to be downloaded or any other way out.SQL Server Express is free of charge.|||I just seached information on sql server expres edition. it Is quite good but what if i need my application to run on network.
is it possible in sql server express edition to run my application on network.|||and another thing as i ve created my application in sql server enterprise manager is it possible to convert my database in sql server express edition|||See here for the differncies between Express and Enterprise editions
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Database restores using Enterprise Manager

Good afternoon. I am using MS SQL 2K and was wondering if it is possible to restore multiple back-up files (database and transaction logs) to a database, if you haven't created a back-up set, using Enterprise Manager. I know that you can write T-SQL to first restore the back-up file and each of the transaction log files, except the last one, with the option of norecovery, and then the last transaction log file, with recovery. Any help would be greatly appreciated. Thank you.

Chris

That the way, restoring the database files one by one.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for the reply, Jens.

Database restore.

Hi everyone,
We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy
database.
When Restoring I have trouble,because while I am killing current user
connections new connections are established and I cannot restore because the
database is in use.
What are my options to get round this issue ?
I connect remotely to the Server to restore.
Regards,Set the database to single user with the rollback option. See ALTER DATABASE in Books Online.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
> Hi everyone,
> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy database.
> When Restoring I have trouble,because while I am killing current user connections new connections
> are established and I cannot restore because the database is in use.
> What are my options to get round this issue ?
> I connect remotely to the Server to restore.
> Regards,
>|||Thanks.
I suppose it does not make any difference if done with ALTER DATABASE or
from Enterpise Manager - Options - Restrict Access - Single User.
Regards,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23Dfd4Gt4GHA.4616@.TK2MSFTNGP05.phx.gbl...
> Set the database to single user with the rollback option. See ALTER
> DATABASE in Books Online.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
> news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
>> Hi everyone,
>> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy
>> database.
>> When Restoring I have trouble,because while I am killing current user
>> connections new connections are established and I cannot restore because
>> the database is in use.
>> What are my options to get round this issue ?
>> I connect remotely to the Server to restore.
>> Regards,
>|||EM doesn't have a rollback option. If users are connected, then the EM operation will fail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
news:OqU%23JXt4GHA.4888@.TK2MSFTNGP03.phx.gbl...
> Thanks.
> I suppose it does not make any difference if done with ALTER DATABASE or from Enterpise Manager -
> Options - Restrict Access - Single User.
> Regards,
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23Dfd4Gt4GHA.4616@.TK2MSFTNGP05.phx.gbl...
>> Set the database to single user with the rollback option. See ALTER DATABASE in Books Online.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Sezgin Rafet" <anonymous@.newsgroup.com> wrote in message
>> news:%23NKvABt4GHA.1012@.TK2MSFTNGP05.phx.gbl...
>> Hi everyone,
>> We have a SQL Server 2000 Enterprise Ed. SP3a Server hosting a busy database.
>> When Restoring I have trouble,because while I am killing current user connections new
>> connections are established and I cannot restore because the database is in use.
>> What are my options to get round this issue ?
>> I connect remotely to the Server to restore.
>> Regards,
>>
>

Database restore.

Wednesday, March 7, 2012

Database Restore

I made a very big mistake. In Enterprise Manager I right clicked on one of
the databases and selected Delete. In addition I answered OK to the
following dialog box. I realize that this was wrong. Now I need to restore
it. Immediately before deleting I right-clicked, selected all tasks and
Backup Database. I can see the file in the \\program files\Microsoft SQL
Sever\MSSQL\BACKUP directory. How do I restore the database using this file.
Try:
restore database MyDB
from disk = 'C:\Program Files\Microsoft SQL Sever\MSSQL\BACKUP\MyDB.bak'
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Robert Brown" <RobertBrown@.discussions.microsoft.com> wrote in message
news:BE05A364-2F57-4FCF-81DE-E4C1A1B2662D@.microsoft.com...
I made a very big mistake. In Enterprise Manager I right clicked on one of
the databases and selected Delete. In addition I answered OK to the
following dialog box. I realize that this was wrong. Now I need to restore
it. Immediately before deleting I right-clicked, selected all tasks and
Backup Database. I can see the file in the \\program files\Microsoft SQL
Sever\MSSQL\BACKUP directory. How do I restore the database using this
file.
|||Hi,
Or from Enterprise manager:-
1. Right click above the databases option
2. All Tasks...Restore database.. Give the database name in "Restore as
database:....
3.CLick the select devices command button
4. Click add and select the backup file
5. Click OK
6. In the main restore screen "Click OK
Thanks
hari
SQL Server mvp
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eqZHAc0sFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Try:
> restore database MyDB
> from disk = 'C:\Program Files\Microsoft SQL Sever\MSSQL\BACKUP\MyDB.bak'
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Robert Brown" <RobertBrown@.discussions.microsoft.com> wrote in message
> news:BE05A364-2F57-4FCF-81DE-E4C1A1B2662D@.microsoft.com...
> I made a very big mistake. In Enterprise Manager I right clicked on one
> of
> the databases and selected Delete. In addition I answered OK to the
> following dialog box. I realize that this was wrong. Now I need to
> restore
> it. Immediately before deleting I right-clicked, selected all tasks and
> Backup Database. I can see the file in the \\program files\Microsoft SQL
> Sever\MSSQL\BACKUP directory. How do I restore the database using this
> file.
>

Tuesday, March 27, 2012

Database Snapshots vs Snaphot replication

Thursday, March 22, 2012

Database Size (Free,Used)

Database Size (Free,Used)

Database Size (Free,Used)

Database size > 250 Gig

Database Size

Database Size

Wednesday, March 21, 2012

Database Service Won't Start

Database Service Won't Start

Database Service Won't Start

Database server layout

Database server layout

Database server layout

Monday, March 19, 2012

Database Schema copy

Sunday, March 11, 2012

Database Runtime

Database restores using Enterprise Manager

Database restore.

Database restore.

Database restore.

Wednesday, March 7, 2012

Database Restore

Database Unit Testing

Blog Archive

About Me