Is it possible to take backup of database for 1 day change?
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
WM_QUIT
RLNI'm not sure what you want to accomplish. Are you saying that you want to re
store the database as it
were at a certain point in time? If so, then you need to look into doing tra
nsaction log backups, as
they give you the ability to perform point-in-time restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 o
f
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
Showing posts with label example. Show all posts
Showing posts with label example. Show all posts
Thursday, February 16, 2012
Tuesday, February 14, 2012
Backup
Is it possible to take backup of database for 1 day change?
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
WM_QUIT
RLN
I'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
WM_QUIT
RLN
I'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
Backup
Is it possible to take backup of database for 1 day change?
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
WM_QUIT
RLN
Not as a backup. You would have to write something to extract the data you
want.
Andrew J. Kelly SQL MVP
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:9BD84D1A-ACC2-4680-BEE2-A41EC04E67B2@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13
> of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
WM_QUIT
RLN
Not as a backup. You would have to write something to extract the data you
want.
Andrew J. Kelly SQL MVP
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:9BD84D1A-ACC2-4680-BEE2-A41EC04E67B2@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13
> of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
Backup
Is it possible to take backup of database for 1 day change?
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
--
WM_QUIT
RLNI'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
also possible to restore it back for the particular date?
for example..
In one month data of database I want to take a backup for changes in 13 of
the month.
if required restore it back.
--
WM_QUIT
RLNI'm not sure what you want to accomplish. Are you saying that you want to restore the database as it
were at a certain point in time? If so, then you need to look into doing transaction log backups, as
they give you the ability to perform point-in-time restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"RLN" <RLN@.discussions.microsoft.com> wrote in message
news:77A5FB86-2765-4036-AA4A-4BA93CA767CB@.microsoft.com...
> Is it possible to take backup of database for 1 day change?
> also possible to restore it back for the particular date?
> for example..
> In one month data of database I want to take a backup for changes in 13 of
> the month.
> if required restore it back.
>
> --
> WM_QUIT
> RLN
Sunday, February 12, 2012
Backing up tr.log on another server
In the main server(for example, THIS_SERVER):
USE master
EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
'\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Everything is normal
I wanted to back up trans. log on the another server in the local net, but
failed.
BACKUP LOG INTERMEDIATE
TO INTERMEDIATE_LOG_DEVICE
WITH NO_TRUNCATE
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or device
off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Could you advice me, how I can solve this problem?
If I back up in the same server - everything is well.I think the problem is with the path. The : could be replaced with a $, as
show below:
'\\ANOTHER_SERVER_NAME\C$\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Even better, why not create a proper share and use the share name instead.
For example: \\ServerName\ShareName ?
Also make sure the SQL Server and Agent service accounts have access to this
share.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alur" <Alur@.discussions.microsoft.com> wrote in message
news:3D089089-AC83-4006-B446-93215CDEE3F6@.microsoft.com...
In the main server(for example, THIS_SERVER):
USE master
EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
'\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Everything is normal
I wanted to back up trans. log on the another server in the local net, but
failed.
BACKUP LOG INTERMEDIATE
TO INTERMEDIATE_LOG_DEVICE
WITH NO_TRUNCATE
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or device
off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Could you advice me, how I can solve this problem?
If I back up in the same server - everything is well.|||You might also need the right permissions on \\ANOTHER_SERVER_NAME\C$
(usually available for admins).
In order to create a connection to a remote disk you can run:
EXEC xp_cmdshell 'net use \\ANOTHER_SERVER_NAME\C$ the_account_password
/USER:THE_ACCOUNT_DOMAIN\TheUserAccount'
Where TheUserAccount has the right access on C$.
BTW: make sure the whole command is in one line
Lionel Chacon
"Narayana Vyas Kondreddi" wrote:
> I think the problem is with the path. The : could be replaced with a $, as
> show below:
> '\\ANOTHER_SERVER_NAME\C$\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
> Even better, why not create a proper share and use the share name instead.
> For example: \\ServerName\ShareName ?
> Also make sure the SQL Server and Agent service accounts have access to th
is
> share.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alur" <Alur@.discussions.microsoft.com> wrote in message
> news:3D089089-AC83-4006-B446-93215CDEE3F6@.microsoft.com...
> In the main server(for example, THIS_SERVER):
> USE master
> EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
> '\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
> Everything is normal
> I wanted to back up trans. log on the another server in the local net, but
> failed.
> BACKUP LOG INTERMEDIATE
> TO INTERMEDIATE_LOG_DEVICE
> WITH NO_TRUNCATE
> Server: Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or devic
e
> off-line. See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP LOG is terminating abnormally.
> Could you advice me, how I can solve this problem?
> If I back up in the same server - everything is well.
>
>|||Thank you very much.
I tried to use
\\ANOTHER_SERVER_NAME\C$ and so on
but the result is the same.
Maybe I must reinstall SQL Server with some another
characteristices(options) ?
"Lionel Chacon" wrote:
> You might also need the right permissions on \\ANOTHER_SERVER_NAME\C$
> (usually available for admins).
> In order to create a connection to a remote disk you can run:
> EXEC xp_cmdshell 'net use \\ANOTHER_SERVER_NAME\C$ the_account_password
> /USER:THE_ACCOUNT_DOMAIN\TheUserAccount'
> Where TheUserAccount has the right access on C$.
> BTW: make sure the whole command is in one line
> --
> Lionel Chacon
>
> "Narayana Vyas Kondreddi" wrote:
>
USE master
EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
'\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Everything is normal
I wanted to back up trans. log on the another server in the local net, but
failed.
BACKUP LOG INTERMEDIATE
TO INTERMEDIATE_LOG_DEVICE
WITH NO_TRUNCATE
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or device
off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Could you advice me, how I can solve this problem?
If I back up in the same server - everything is well.I think the problem is with the path. The : could be replaced with a $, as
show below:
'\\ANOTHER_SERVER_NAME\C$\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Even better, why not create a proper share and use the share name instead.
For example: \\ServerName\ShareName ?
Also make sure the SQL Server and Agent service accounts have access to this
share.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Alur" <Alur@.discussions.microsoft.com> wrote in message
news:3D089089-AC83-4006-B446-93215CDEE3F6@.microsoft.com...
In the main server(for example, THIS_SERVER):
USE master
EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
'\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
Everything is normal
I wanted to back up trans. log on the another server in the local net, but
failed.
BACKUP LOG INTERMEDIATE
TO INTERMEDIATE_LOG_DEVICE
WITH NO_TRUNCATE
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or device
off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP LOG is terminating abnormally.
Could you advice me, how I can solve this problem?
If I back up in the same server - everything is well.|||You might also need the right permissions on \\ANOTHER_SERVER_NAME\C$
(usually available for admins).
In order to create a connection to a remote disk you can run:
EXEC xp_cmdshell 'net use \\ANOTHER_SERVER_NAME\C$ the_account_password
/USER:THE_ACCOUNT_DOMAIN\TheUserAccount'
Where TheUserAccount has the right access on C$.
BTW: make sure the whole command is in one line
Lionel Chacon
"Narayana Vyas Kondreddi" wrote:
> I think the problem is with the path. The : could be replaced with a $, as
> show below:
> '\\ANOTHER_SERVER_NAME\C$\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
> Even better, why not create a proper share and use the share name instead.
> For example: \\ServerName\ShareName ?
> Also make sure the SQL Server and Agent service accounts have access to th
is
> share.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Alur" <Alur@.discussions.microsoft.com> wrote in message
> news:3D089089-AC83-4006-B446-93215CDEE3F6@.microsoft.com...
> In the main server(for example, THIS_SERVER):
> USE master
> EXEC sp_addumpdevice 'disk', 'INTERMEDIATE_LOG_DEVICE',
> '\\ANOTHER_SERVER_NAME\C:\SOME_FOLDER_NA
ME\ INTERMEDIATE_LOG.DAT'
> Everything is normal
> I wanted to back up trans. log on the another server in the local net, but
> failed.
> BACKUP LOG INTERMEDIATE
> TO INTERMEDIATE_LOG_DEVICE
> WITH NO_TRUNCATE
> Server: Msg 3201, Level 16, State 1, Line 1
> Cannot open backup device 'INTERMEDIATE_LOG_DEVICE'. Device error or devic
e
> off-line. See the SQL Server error log for more details.
> Server: Msg 3013, Level 16, State 1, Line 1
> BACKUP LOG is terminating abnormally.
> Could you advice me, how I can solve this problem?
> If I back up in the same server - everything is well.
>
>|||Thank you very much.
I tried to use
\\ANOTHER_SERVER_NAME\C$ and so on
but the result is the same.
Maybe I must reinstall SQL Server with some another
characteristices(options) ?
"Lionel Chacon" wrote:
> You might also need the right permissions on \\ANOTHER_SERVER_NAME\C$
> (usually available for admins).
> In order to create a connection to a remote disk you can run:
> EXEC xp_cmdshell 'net use \\ANOTHER_SERVER_NAME\C$ the_account_password
> /USER:THE_ACCOUNT_DOMAIN\TheUserAccount'
> Where TheUserAccount has the right access on C$.
> BTW: make sure the whole command is in one line
> --
> Lionel Chacon
>
> "Narayana Vyas Kondreddi" wrote:
>
Subscribe to:
Posts (Atom)