Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser window
Hi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>
|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegr oups.com...
|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>
|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegro ups.com...
Showing posts with label point. Show all posts
Showing posts with label point. Show all posts
Friday, March 30, 2012
How to create server alias
Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add
a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>|||ok, many thanks
Uri Dimant wrote:[vbcol=seagreen]
> Well, If I understood you , take a look at Client Network Utility to add
a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
How to create server alias
Can anyone descrive in principle how a Web server alias is actually set
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> > Can anyone descrive in principle how a Web server alias is actually set
> > up? How do you get a server alias to point to a particular server with
> > a particular IP address within a large organisation? The outcome being
> > that when a user types the alias url into the address bar, the correct
> > page appears in the browser window
> >|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>|||ok, many thanks
Uri Dimant wrote:
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
> >I would think so, as we use it in our organisation
> > Uri Dimant wrote:
> >> Hi
> >>
> >> Does it somehow relate to SQL Server?
> >>
> >>
> >> <simonaj30@.yahoo.co.uk> wrote in message
> >> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> >> > Can anyone descrive in principle how a Web server alias is actually set
> >> > up? How do you get a server alias to point to a particular server with
> >> > a particular IP address within a large organisation? The outcome being
> >> > that when a user types the alias url into the address bar, the correct
> >> > page appears in the browser window
> >> >
> >|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>sql
up? How do you get a server alias to point to a particular server with
a particular IP address within a large organisation? The outcome being
that when a user types the alias url into the address bar, the correct
page appears in the browser windowHi
Does it somehow relate to SQL Server?
<simonaj30@.yahoo.co.uk> wrote in message
news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> Can anyone descrive in principle how a Web server alias is actually set
> up? How do you get a server alias to point to a particular server with
> a particular IP address within a large organisation? The outcome being
> that when a user types the alias url into the address bar, the correct
> page appears in the browser window
>|||I would think so, as we use it in our organisation
Uri Dimant wrote:
> Hi
> Does it somehow relate to SQL Server?
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> > Can anyone descrive in principle how a Web server alias is actually set
> > up? How do you get a server alias to point to a particular server with
> > a particular IP address within a large organisation? The outcome being
> > that when a user types the alias url into the address bar, the correct
> > page appears in the browser window
> >|||Well, If I understood you , take a look at Client Network Utility to add a
new alias to the server
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>|||ok, many thanks
Uri Dimant wrote:
> Well, If I understood you , take a look at Client Network Utility to add a
> new alias to the server
>
> <simonaj30@.yahoo.co.uk> wrote in message
> news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
> >I would think so, as we use it in our organisation
> > Uri Dimant wrote:
> >> Hi
> >>
> >> Does it somehow relate to SQL Server?
> >>
> >>
> >> <simonaj30@.yahoo.co.uk> wrote in message
> >> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
> >> > Can anyone descrive in principle how a Web server alias is actually set
> >> > up? How do you get a server alias to point to a particular server with
> >> > a particular IP address within a large organisation? The outcome being
> >> > that when a user types the alias url into the address bar, the correct
> >> > page appears in the browser window
> >> >
> >|||You right Uri...
Post this in question in Internet Information service(IIS) group. This is
done through IIS configuration.
This is SQL Server group.
vinu
<simonaj30@.yahoo.co.uk> wrote in message
news:1162896637.485781.85960@.m73g2000cwd.googlegroups.com...
>I would think so, as we use it in our organisation
> Uri Dimant wrote:
>> Hi
>> Does it somehow relate to SQL Server?
>>
>> <simonaj30@.yahoo.co.uk> wrote in message
>> news:1162895112.082029.220030@.i42g2000cwa.googlegroups.com...
>> > Can anyone descrive in principle how a Web server alias is actually set
>> > up? How do you get a server alias to point to a particular server with
>> > a particular IP address within a large organisation? The outcome being
>> > that when a user types the alias url into the address bar, the correct
>> > page appears in the browser window
>> >
>sql
Monday, March 26, 2012
how to create filegroups
I was directed to create filegroups so that clients that install msde or sql
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:
> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>
server would look the same Can anyone point me in the right direction on how
to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this
point. Is this what a sql server install would do so that they could take
advantage of Raid drive?
See Filegroups|Creating in Books Online. The basic syntax is:
ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
Then add files to the filegroup with:
ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
<filegroupname>
Jacco Schalkwijk
SQL Server MVP
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>I was directed to create filegroups so that clients that install msde or
>sql
> server would look the same Can anyone point me in the right direction on
> how
> to
> create the filegroups on msde.
> I was thinking about just splitting up the indexes and tables at this
> point. Is this what a sql server install would do so that they could take
> advantage of Raid drive?
>
|||i appreciate the information
thanx
"Jacco Schalkwijk" wrote:
> See Filegroups|Creating in Books Online. The basic syntax is:
> ALTER DATABASE <dbname> ADD FILEGROUP <filegroupname>
> Then add files to the filegroup with:
> ALTER DATABASE <dbname> ADD FILE (NAME = <filename>) TO FILEGROUP
> <filegroupname>
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:A271C5F7-636B-4E88-B2EE-D9DFED0FB3DF@.microsoft.com...
>
>
Friday, February 24, 2012
how to copy sql server database
how do I go about copying a sql server database on my Vista
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||... and if needed also bring the logins. Google for sp_help_revlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||Hi Steve,
Just make a backup (using the SQL Server backup engine) of the
Vista-based database to a network share on your W2K3 server then restore
that backup on the W2K3 machine. This should look something as follows:
--On the Vista PC
backup database mydb
to disk = '\\w2k3server\myshare\mydb.bak'
--On the W2K3 Server
restore database mydb
from disk = 'c:\mysharedfolder\mydb.bak'
Hope this helps!
Jonathan
Steve Richter wrote:
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||On Jul 19, 5:00 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
>
gosh, that was easy. The only thing I add knowledge wise is I had to
first install the sql server managment studio express on my Vista PC.
thanks,
-Steve
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||... and if needed also bring the logins. Google for sp_help_revlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||Hi Steve,
Just make a backup (using the SQL Server backup engine) of the
Vista-based database to a network share on your W2K3 server then restore
that backup on the W2K3 machine. This should look something as follows:
--On the Vista PC
backup database mydb
to disk = '\\w2k3server\myshare\mydb.bak'
--On the W2K3 Server
restore database mydb
from disk = 'c:\mysharedfolder\mydb.bak'
Hope this helps!
Jonathan
Steve Richter wrote:
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||On Jul 19, 5:00 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on the W2K3 machine.
>
gosh, that was easy. The only thing I add knowledge wise is I had to
first install the sql server managment studio express on my Vista PC.
thanks,
-Steve
Sunday, February 19, 2012
how to copy sql server database
how do I go about copying a sql server database on my Vista
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,
... and if needed also bring the logins. Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegro ups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,
... and if needed also bring the logins. Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegro ups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>
how to copy sql server database
how do I go about copying a sql server database on my Vista
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on t
he W2K3 machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||... and if needed also bring the logins. Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||Hi Steve,
Just make a backup (using the SQL Server backup engine) of the
Vista-based database to a network share on your W2K3 server then restore
that backup on the W2K3 machine. This should look something as follows:
--On the Vista PC
backup database mydb
to disk = '\\w2k3server\myshare\mydb.bak'
--On the W2K3 Server
restore database mydb
from disk = 'c:\mysharedfolder\mydb.bak'
Hope this helps!
Jonathan
Steve Richter wrote:
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||On Jul 19, 5:00 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on
the W2K3 machine.
>
gosh, that was easy. The only thing I add knowledge wise is I had to
first install the sql server managment studio express on my Vista PC.
thanks,
-Steve
development PC to my W2K3 server PC?
Could some just point me in the right direction? Admittedly I have
other issues to resolve in that my Vista development PC cant connect
to sql server on my server PC. ( file sharing works however )
thanks,I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on t
he W2K3 machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||... and if needed also bring the logins. Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Richter" <StephenRichter@.gmail.com> wrote in message
news:1184878323.661887.142540@.m3g2000hsh.googlegroups.com...
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||Hi Steve,
Just make a backup (using the SQL Server backup engine) of the
Vista-based database to a network share on your W2K3 server then restore
that backup on the W2K3 machine. This should look something as follows:
--On the Vista PC
backup database mydb
to disk = '\\w2k3server\myshare\mydb.bak'
--On the W2K3 Server
restore database mydb
from disk = 'c:\mysharedfolder\mydb.bak'
Hope this helps!
Jonathan
Steve Richter wrote:
> how do I go about copying a sql server database on my Vista
> development PC to my W2K3 server PC?
> Could some just point me in the right direction? Admittedly I have
> other issues to resolve in that my Vista development PC cant connect
> to sql server on my server PC. ( file sharing works however )
> thanks,
>|||On Jul 19, 5:00 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> I'd do a BACKUP DATABASE on the Vista machine and then RESTORE DATABASE on
the W2K3 machine.
>
gosh, that was easy. The only thing I add knowledge wise is I had to
first install the sql server managment studio express on my Vista PC.
thanks,
-Steve
Subscribe to:
Comments (Atom)