I got 2 questions, if tempdb is full, how to fix it? 2. if I have full backup
yesterday and no transaction log today and I delete data by accident, is
there any way to recover it?
Thanks.1)
http://www.aspfaq.com/show.asp?id=2446
2)
http://www.lumigent.com/ --explorer log for sql
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com...
>I got 2 questions, if tempdb is full, how to fix it? 2. if I have full
>backup
> yesterday and no transaction log today and I delete data by accident, is
> there any way to recover it?
> Thanks.
>
Showing posts with label fix. Show all posts
Showing posts with label fix. Show all posts
Friday, March 30, 2012
I got 2 question, if tempdb is full, how to fix it? 2. if I have f
I got 2 questions, if tempdb is full, how to fix it? 2. if I have full backu
p
yesterday and no transaction log today and I delete data by accident, is
there any way to recover it?
Thanks.1)
http://www.aspfaq.com/show.asp?id=2446
2)
http://www.lumigent.com/ --explorer log for sql
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com...
>I got 2 questions, if tempdb is full, how to fix it? 2. if I have full
>backup
> yesterday and no transaction log today and I delete data by accident, is
> there any way to recover it?
> Thanks.
>
p
yesterday and no transaction log today and I delete data by accident, is
there any way to recover it?
Thanks.1)
http://www.aspfaq.com/show.asp?id=2446
2)
http://www.lumigent.com/ --explorer log for sql
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com...
>I got 2 questions, if tempdb is full, how to fix it? 2. if I have full
>backup
> yesterday and no transaction log today and I delete data by accident, is
> there any way to recover it?
> Thanks.
>
Monday, March 26, 2012
I can't restore my master DB
I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
>
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
>
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>
I can't restore my master DB
I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> > I have 2 servers (Prod & Staging)
> >
> > Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> > Staging is running SQL 2k Enterprise SP2
> >
> > I can't get the versions to match, thus I can't restore any of my backed
> up databases to the staging server from the production one.
> >
> > ---
> >
> > Server: Msg 3168, Level 16, State 1, Line 1
> > The backup of the system database on device g:\DBBACKUP\Master.bak cannot
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
>
>
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be restored because it was created by a different version of the server (134218407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that altered the version on the production box and he didn't implement the same fix on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
> ----
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> > I have 2 servers (Prod & Staging)
> >
> > Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> > Staging is running SQL 2k Enterprise SP2
> >
> > I can't get the versions to match, thus I can't restore any of my backed
> up databases to the staging server from the production one.
> >
> > ---
> >
> > Server: Msg 3168, Level 16, State 1, Line 1
> > The backup of the system database on device g:\DBBACKUP\Master.bak cannot
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
>
>
Friday, March 23, 2012
I can't restore my master DB
I have 2 servers (Prod & Staging)
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up
databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be
restored because it was created by a different version of the server (13421
8407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that alt
ered the version on the production box and he didn't implement the same fix
on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>
Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
Staging is running SQL 2k Enterprise SP2
I can't get the versions to match, thus I can't restore any of my backed up
databases to the staging server from the production one.
---
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device g:\DBBACKUP\Master.bak cannot be
restored because it was created by a different version of the server (13421
8407) than this server (134218262).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.I would determine what versions you are running on both, and then upgrade
staging to match production. Is this possible?
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"HELP! Can't Restore DB's" <HELP! Can't Restore
DB's@.discussions.microsoft.com> wrote in message
news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> I have 2 servers (Prod & Staging)
> Prod is running SQL 2k Enterprise SP2 (obviously with some fix)
> Staging is running SQL 2k Enterprise SP2
> I can't get the versions to match, thus I can't restore any of my backed
up databases to the staging server from the production one.
> ---
> Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device g:\DBBACKUP\Master.bak cannot
be restored because it was created by a different version of the server
(134218407) than this server (134218262).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>|||I figured out the problem. A network guy implemented a security fix that alt
ered the version on the production box and he didn't implement the same fix
on the Staging box.
"Gregory A. Larsen" wrote:
> I would determine what versions you are running on both, and then upgrade
> staging to match production. Is this possible?
>
> --
> ----
--
> ----
--
> --
> Need SQL Server Examples check out my website at
> http://www.geocities.com/sqlserverexamples
> "HELP! Can't Restore DB's" <HELP! Can't Restore
> DB's@.discussions.microsoft.com> wrote in message
> news:75D5B62B-2A21-4BF4-889C-92CE4A645F36@.microsoft.com...
> up databases to the staging server from the production one.
> be restored because it was created by a different version of the server
> (134218407) than this server (134218262).
>
>
I cant make new SQL Server Registration
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.
cheers
gola munjal
Originally posted by yajai
When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is
Pinging 216.58.174.179 with 32 bytes of data:
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.
Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.
Subscribe to:
Posts (Atom)