Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

Database group

In sql server 2005 you have a group of databases called System Databases -
Is it possible to create your own database group?

Best regards,

Jakobsgaard
If you mean in the Object Explorer tree, no not in this version.|||

This seems like a tease. Is this in grouping the works?

I am coming from an Oracle perspective where the world revolves around Schemas and Tablespaces.

The Database group makes sense to me.

Thanks

Database gets detatched from the Database Group

Hi everybody,

Everyday at 11pm my database gets detatched from the database group. In the event log I get this message:

Event ID: 17052

Description: Error 17803, Severity: 20, State:14

Insufficient memory available.

After a reboot, everything is fine. But this happens everyday. Any suggestions on what I should do?

comadmin

What applications are running at this time of the day? You can monitor your server for any activity that might be causing thissql

Database File

Hello, I have a database with a very big datafile (6 gb), and I would Like to add more datafiles and why not 1 more db group... How do I distribute the data to the new datafiles ?

I'm doing this cause I'm having some serious performance problems...

Should I create those datafiles on separate disks or in the same one ?

Thank you so much for your help...

refer these

http://www.mssqlcity.com/FAQ/Devel/move_tables.htm

http://www.mssqltips.com/tip.asp?tip=1112

Madhu

|||

Hi Julian,

I am afraid, there is no simple answer to this question.

It all depends on how your storage is configured.

There is one important point, if you have two different datafiles sitting on two different logical drives at the windows level, SQL Server will use two threads to perform the IO. So you might see a bit of a performance benefit in that.

E.g. You have two drives E and F and your current file is on drive E. I would add another data file on the F Drive in the same filegroup.

regards

Jag

Database Field showing as zero in report footer but works in group footer

I'm fairly new to crystal so there may be an obvious solution but I just can't find it. So any help what-so-ever would be excellent and much appreciated...

Problem:

Database field shows correct value and works in formulas properly in group footer.
In Report footer this same database field shows as zero and therefore other formulas in the report footer do not calculate correctly.

Any solutions?Please. Any help would be greatly appreciated. I'm kind of in a time crunch.

I'm not sure why a database field would show the value in the group footer and come up zero in the report footer.

Any ideas??|||Sorry, don't know why either - the report footer always shows the final database record for me!
I have read of other people having this problem, and I believe that assigning the fiele to a shared variable has allowed the value to be used.|||I gave it a variable and now it works. How weird is that?!

Thanks for your help!sql

Database Diagram and SP4

I had originally posted this in the sqlserver.server group, which was
probably incorrect. So, I thought I would try the tools group. Sorry to those
who end up reading it twice
I installed SP4 on my local SQL Server and all is well, except...
The database designer is behaving a little differently. If I move or resize
a table, the relationship lines are re-arranged more radically than they were
in the previous version (SP3). After this, the lines (including simple
straight lines) seem to have a break in the middle, and it is impossible to
reposition a simple line by dragging the whole thing at once. You have to
drag the top and bottom (or left and right) halves separately, and then they
rarely line up in a straight line again. If you drag on the break in the
middle, the line will, in some cases, create new sections and double back on
itself.
Is this a bug in SP4? Is there any way to change this behavior?
Hi
I have not noticed anything different, but it does seem to render quicker.
I will play with it a bit to see what I find.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ray Novak" <RayNovak@.discussions.microsoft.com> wrote in message
news:DE21797B-73D9-422E-8CB6-FF12EA21A986@.microsoft.com...
>I had originally posted this in the sqlserver.server group, which was
> probably incorrect. So, I thought I would try the tools group. Sorry to
> those
> who end up reading it twice
> I installed SP4 on my local SQL Server and all is well, except...
> The database designer is behaving a little differently. If I move or
> resize
> a table, the relationship lines are re-arranged more radically than they
> were
> in the previous version (SP3). After this, the lines (including simple
> straight lines) seem to have a break in the middle, and it is impossible
> to
> reposition a simple line by dragging the whole thing at once. You have to
> drag the top and bottom (or left and right) halves separately, and then
> they
> rarely line up in a straight line again. If you drag on the break in the
> middle, the line will, in some cases, create new sections and double back
> on
> itself.
> Is this a bug in SP4? Is there any way to change this behavior?
>
|||Thanx Mike - I have also noticed that the diagrams seem faster.
It seems that this problem applies to diagrams I created "pre-SP4". I tried
creating a new diagram and it is (so far) behaving correctly.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> I have not noticed anything different, but it does seem to render quicker.
> I will play with it a bit to see what I find.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Ray Novak" <RayNovak@.discussions.microsoft.com> wrote in message
> news:DE21797B-73D9-422E-8CB6-FF12EA21A986@.microsoft.com...
>
>

Database deployment

Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what they
all are.
But, how do I move our database from our server, onto our customers
server?
Thanks
Gareth Sharp
you have a couple of option, two that pop up into my head (this early) are
backup and restore
detach and attach
http://sqlservercode.blogspot.com/
"Gareth Sharp" wrote:

> Hi there
> Firstly, apologies for the multi-post - I could not decide which group would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
>
|||Hi,
If the database size is small just backup and write in CD or TAPE.
and Restore it on the client side.
Also backup the master,msdb and model database.
from
Doller
|||doller wrote:
> Hi,
> If the database size is small just backup and write in CD or TAPE.
> and Restore it on the client side.
> Also backup the master,msdb and model database.
> from
> Doller
>
Why would you backup Master, MSDB and Model in this case? I'd just
backup the user database and restore it on the customers server.
Another option could be to script out the database etc. and then run
this script on the customers server.
Regards
Steen
|||We use SQL scripts rather than backup/restore or detach/attach. This
provides both new and upgrade install functionality and works well since we
also keep or DDL scripts under source control.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||These may help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||I also prefer scripts instead of a binary copy of the database. Among other things, when a binary
copy is distributed, you need to make 100% certain that the app work with different collation on the
system databases.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
> We use SQL scripts rather than backup/restore or detach/attach. This provides both new and
> upgrade install functionality and works well since we also keep or DDL scripts under source
> control.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
>
|||hi Gareth,
Gareth Sharp wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which
> group would be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know
> what they all are.
> But, how do I move our database from our server, onto our customers
> server?
I'm with Dan and Tibor...
try having a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article and implies support for versioning and source control..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||And you need to remap users to logins on the new server as well when you use
a backup, because the mapping uses the SID. Scripts will just generate the
user and map it to the login without using a autogenerated ID.
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMy3dGAzFHA.3856@.tk2msftngp13.phx.gbl...
>I also prefer scripts instead of a binary copy of the database. Among other
>things, when a binary copy is distributed, you need to make 100% certain
>that the app work with different collation on the system databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
>

Database deployment

Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what they
all are.
But, how do I move our database from our server, onto our customers
server?
Thanks
Gareth Sharp
you have a couple of option, two that pop up into my head (this early) are
backup and restore
detach and attach
http://sqlservercode.blogspot.com/
"Gareth Sharp" wrote:

> Hi there
> Firstly, apologies for the multi-post - I could not decide which group would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
>
|||Hi,
If the database size is small just backup and write in CD or TAPE.
and Restore it on the client side.
Also backup the master,msdb and model database.
from
Doller
|||doller wrote:
> Hi,
> If the database size is small just backup and write in CD or TAPE.
> and Restore it on the client side.
> Also backup the master,msdb and model database.
> from
> Doller
>
Why would you backup Master, MSDB and Model in this case? I'd just
backup the user database and restore it on the customers server.
Another option could be to script out the database etc. and then run
this script on the customers server.
Regards
Steen
|||We use SQL scripts rather than backup/restore or detach/attach. This
provides both new and upgrade install functionality and works well since we
also keep or DDL scripts under source control.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||These may help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||I also prefer scripts instead of a binary copy of the database. Among other things, when a binary
copy is distributed, you need to make 100% certain that the app work with different collation on the
system databases.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
> We use SQL scripts rather than backup/restore or detach/attach. This provides both new and
> upgrade install functionality and works well since we also keep or DDL scripts under source
> control.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
>
|||hi Gareth,
Gareth Sharp wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which
> group would be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know
> what they all are.
> But, how do I move our database from our server, onto our customers
> server?
I'm with Dan and Tibor...
try having a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article and implies support for versioning and source control..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||And you need to remap users to logins on the new server as well when you use
a backup, because the mapping uses the SID. Scripts will just generate the
user and map it to the login without using a autogenerated ID.
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMy3dGAzFHA.3856@.tk2msftngp13.phx.gbl...
>I also prefer scripts instead of a binary copy of the database. Among other
>things, when a binary copy is distributed, you need to make 100% certain
>that the app work with different collation on the system databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
>

Database deployment

Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what they
all are.
But, how do I move our database from our server, onto our customers
server?
Thanks
Gareth Sharp
you have a couple of option, two that pop up into my head (this early) are
backup and restore
detach and attach
http://sqlservercode.blogspot.com/
"Gareth Sharp" wrote:

> Hi there
> Firstly, apologies for the multi-post - I could not decide which group would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
>
|||Hi,
If the database size is small just backup and write in CD or TAPE.
and Restore it on the client side.
Also backup the master,msdb and model database.
from
Doller
|||doller wrote:
> Hi,
> If the database size is small just backup and write in CD or TAPE.
> and Restore it on the client side.
> Also backup the master,msdb and model database.
> from
> Doller
>
Why would you backup Master, MSDB and Model in this case? I'd just
backup the user database and restore it on the customers server.
Another option could be to script out the database etc. and then run
this script on the customers server.
Regards
Steen
|||We use SQL scripts rather than backup/restore or detach/attach. This
provides both new and upgrade install functionality and works well since we
also keep or DDL scripts under source control.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||These may help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
|||I also prefer scripts instead of a binary copy of the database. Among other things, when a binary
copy is distributed, you need to make 100% certain that the app work with different collation on the
system databases.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
> We use SQL scripts rather than backup/restore or detach/attach. This provides both new and
> upgrade install functionality and works well since we also keep or DDL scripts under source
> control.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
>
|||hi Gareth,
Gareth Sharp wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which
> group would be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know
> what they all are.
> But, how do I move our database from our server, onto our customers
> server?
I'm with Dan and Tibor...
try having a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article and implies support for versioning and source control..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||And you need to remap users to logins on the new server as well when you use
a backup, because the mapping uses the SID. Scripts will just generate the
user and map it to the login without using a autogenerated ID.
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMy3dGAzFHA.3856@.tk2msftngp13.phx.gbl...
>I also prefer scripts instead of a binary copy of the database. Among other
>things, when a binary copy is distributed, you need to make 100% certain
>that the app work with different collation on the system databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
>

Database deployment

Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what they
all are.
But, how do I move our database from our server, onto our customers
server?
Thanks
Gareth Sharpyou have a couple of option, two that pop up into my head (this early) are
backup and restore
detach and attach
http://sqlservercode.blogspot.com/
"Gareth Sharp" wrote:

> Hi there
> Firstly, apologies for the multi-post - I could not decide which group wou
ld
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what th
ey
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
>|||Hi,
If the database size is small just backup and write in CD or TAPE.
and Restore it on the client side.
Also backup the master,msdb and model database.
from
Doller|||doller wrote:
> Hi,
> If the database size is small just backup and write in CD or TAPE.
> and Restore it on the client side.
> Also backup the master,msdb and model database.
> from
> Doller
>
Why would you backup Master, MSDB and Model in this case? I'd just
backup the user database and restore it on the customers server.
Another option could be to script out the database etc. and then run
this script on the customers server.
Regards
Steen|||We use SQL scripts rather than backup/restore or detach/attach. This
provides both new and upgrade install functionality and works well since we
also keep or DDL scripts under source control.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>|||These may help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>|||I also prefer scripts instead of a binary copy of the database. Among other
things, when a binary
copy is distributed, you need to make 100% certain that the app work with di
fferent collation on the
system databases.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
> We use SQL scripts rather than backup/restore or detach/attach. This prov
ides both new and
> upgrade install functionality and works well since we also keep or DDL scr
ipts under source
> control.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message news:di5bpa$1g3$1$8300d
ec7@.news.demon.co.uk...
>|||hi Gareth,
Gareth Sharp wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which
> group would be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know
> what they all are.
> But, how do I move our database from our server, onto our customers
> server?
I'm with Dan and Tibor...
try having a look at
http://msdn.microsoft.com/msdnmag/i...abaseinstaller/ ...
it's a good article and implies support for versioning and source control..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||And you need to remap users to logins on the new server as well when you use
a backup, because the mapping uses the SID. Scripts will just generate the
user and map it to the login without using a autogenerated ID.
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMy3dGAzFHA.3856@.tk2msftngp13.phx.gbl...
>I also prefer scripts instead of a binary copy of the database. Among other
>things, when a binary copy is distributed, you need to make 100% certain
>that the app work with different collation on the system databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
>

Database deployment

Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what they
all are.
But, how do I move our database from our server, onto our customers
server?
Thanks
Gareth Sharpyou have a couple of option, two that pop up into my head (this early) are
backup and restore
detach and attach
http://sqlservercode.blogspot.com/
"Gareth Sharp" wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>
>|||Hi,
If the database size is small just backup and write in CD or TAPE.
and Restore it on the client side.
Also backup the master,msdb and model database.
from
Doller|||doller wrote:
> Hi,
> If the database size is small just backup and write in CD or TAPE.
> and Restore it on the client side.
> Also backup the master,msdb and model database.
> from
> Doller
>
Why would you backup Master, MSDB and Model in this case? I'd just
backup the user database and restore it on the customers server.
Another option could be to script out the database etc. and then run
this script on the customers server.
Regards
Steen|||We use SQL scripts rather than backup/restore or detach/attach. This
provides both new and upgrade install functionality and works well since we
also keep or DDL scripts under source control.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>|||These may help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
> Hi there
> Firstly, apologies for the multi-post - I could not decide which group
> would
> be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know what
> they
> all are.
> But, how do I move our database from our server, onto our customers
> server?
> Thanks
> Gareth Sharp
>|||I also prefer scripts instead of a binary copy of the database. Among other things, when a binary
copy is distributed, you need to make 100% certain that the app work with different collation on the
system databases.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
> We use SQL scripts rather than backup/restore or detach/attach. This provides both new and
> upgrade install functionality and works well since we also keep or DDL scripts under source
> control.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
>> Hi there
>> Firstly, apologies for the multi-post - I could not decide which group would
>> be best to post this to.
>> I have a simple (I think) question.
>> We are about to roll out our first SQL server based application. The
>> application and run times are no problems - I'm pretty sure I know what they
>> all are.
>> But, how do I move our database from our server, onto our customers
>> server?
>> Thanks
>> Gareth Sharp
>>
>|||hi Gareth,
Gareth Sharp wrote:
> Hi there
> Firstly, apologies for the multi-post - I could not decide which
> group would be best to post this to.
> I have a simple (I think) question.
> We are about to roll out our first SQL server based application. The
> application and run times are no problems - I'm pretty sure I know
> what they all are.
> But, how do I move our database from our server, onto our customers
> server?
I'm with Dan and Tibor...
try having a look at
http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/ ...
it's a good article and implies support for versioning and source control..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||And you need to remap users to logins on the new server as well when you use
a backup, because the mapping uses the SID. Scripts will just generate the
user and map it to the login without using a autogenerated ID.
--
Jacco Schalkwijk
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMy3dGAzFHA.3856@.tk2msftngp13.phx.gbl...
>I also prefer scripts instead of a binary copy of the database. Among other
>things, when a binary copy is distributed, you need to make 100% certain
>that the app work with different collation on the system databases.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Oj9tlvzyFHA.3720@.TK2MSFTNGP14.phx.gbl...
>> We use SQL scripts rather than backup/restore or detach/attach. This
>> provides both new and upgrade install functionality and works well since
>> we also keep or DDL scripts under source control.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Gareth Sharp" <gs@.paxsoft.co.uk> wrote in message
>> news:di5bpa$1g3$1$8300dec7@.news.demon.co.uk...
>> Hi there
>> Firstly, apologies for the multi-post - I could not decide which group
>> would
>> be best to post this to.
>> I have a simple (I think) question.
>> We are about to roll out our first SQL server based application. The
>> application and run times are no problems - I'm pretty sure I know what
>> they
>> all are.
>> But, how do I move our database from our server, onto our customers
>> server?
>> Thanks
>> Gareth Sharp
>>
>>
>